Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question about Show Partial Sums in pivot table

I am using a pivot table with 'show partial sums' on the Brand/Generic column (column 2):

error loading image

However, I really need the Price Term values sub-totaled within the 'Combined' section like this:

error loading image

Any suggestions on how to accomplish this? I'm guessing 'show partial sums' isn't going to be sufficient.

2 Replies
Not applicable
Author

Did you try enabling Partial Sums for Brand/Gen column and Price Term Column.

Not applicable
Author

Yes, the top screen cap is the result of having both of them enabled. Is my only solution going to be two sheet objects? I sure hope I'm wrong. It's not the most end-user friendly...