Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrthomasshelby
Creator III
Creator III

Subtotal in Pivot table by one particular Dimension

Hello,

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

Table1.png

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:

Table2.PNG

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!

stalwar1tresescokaushik.solanki

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Not sure if I understood right. May be like:

Capture.JPG

View solution in original post

2 Replies
tresesco
MVP
MVP

Not sure if I understood right. May be like:

Capture.JPG

mrthomasshelby
Creator III
Creator III
Author

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