Subtotal in Pivot table by one particular Dimension

mrthomasshelby — Tue, 07 Aug 2018 08:10:06 GMT

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‌

Re: Subtotal in Pivot table by one particular Dimension

tresB — Tue, 07 Aug 2018 08:29:00 GMT

Not sure if I understood right. May be like:

Re: Subtotal in Pivot table by one particular Dimension

mrthomasshelby — Tue, 07 Aug 2018 08:34:56 GMT

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

topic Subtotal in Pivot table by one particular Dimension in QlikView

Subtotal in Pivot table by one particular Dimension

Re: Subtotal in Pivot table by one particular Dimension

Re: Subtotal in Pivot table by one particular Dimension