Subtotal in Pivot table by one particular Dimension

[mrthomasshelby]

Hello,

I have a pivot table in my app that looks like this:

Now, I would like to have a line in the table that gives the totals for each Bidder by the dimension Category. For example, in 'Package A' Bidder A's subtotal for the category 'Equipments' is 14195 and Bidder B's subtotal for the same category is 14592. I'd like to see the subtotals for each category for each bidder. Looking for something like this:

I do know that there's a subtotal option in the Presentation tab, but it gives me the subtotal from that dimension for all the lines together. I tried instead by doing an expression in the dimensions like this:

Sum(Aggr([Total Price],No.,[Package Name],[Specification 1],[Specification 2],Ser.Category,[Component Bid No],[CB_1 Cost Element],Supplier))

but it doesn't seem to work.

Please help me get this subtotal. Attaching the sample to the post. Thanks in advance!

stalwar1‌ tresesco‌ kaushik.solanki‌

[tresesco · Accepted solution]

Not sure if I understood right. May be like:

[mrthomasshelby]

Just found out you can do subtotals by different dimensions. This works. Thanks a lot!