Aggregation on a Pivot Table

[#1]

I am trying to aggegate the totals of the standard margin of several Classes in a Category total and cannot seem to find the right formula.  I have attached the object, and thank you in advance for any assistance provided.

[#2]

On what basis do you want to group the classes?

Regards,

Kirann

[#3 · Accepted solution]

Try it by changing the expression as below.

sum(ExtensionAmt * MarginPct)

Hope this is what you were looking for.

Regards,

Sajeevan

[#4]

Thank you very much!  Amazing what happens by moving a close bracket.

Regards.