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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table grand total aggregate

hi,

I have a pivot table which shows total sales by region. when i filter 2 countries, the grand total column shows total of these 2 countries i.e. 800 (UK + Germany).

My requirement is that in the grand total row of table-1, the total of all the Countries i.e. 1300 should come as given in table 2.

pivot_table.JPG

Thus, my output should be like:

pivot_table2.JPG

Any suggestions on this are welcome!

TIA,

Karan

0 Replies