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: 
qlikuser2000
Contributor
Contributor

Subtotals in pivot tables at the end of the table

Hi all,

I have pivot table, and I can show subtotals for countries after each country but the client wants to have subtotals at the end of the table like in the image.  The table is always fully expanded,and the number of countries and regions can be variable. Also The text for countries subtotal can be customized.

clipboard_image_0.png

Thank you all for your help in advance.

Labels (2)
1 Solution

Accepted Solutions
qlikuser2000
Contributor
Contributor
Author

The solution is to create dummy dimension  and then for used dimensions in pivot table to use:

- for country :   =if (DummyDim<>1, 'SubTotal', pick(DummyDim,Country))

- for region:  =if(DummyDim=1, RegionName, Country)

this is the result:

clipboard_image_0.png

View solution in original post

1 Reply
qlikuser2000
Contributor
Contributor
Author

The solution is to create dummy dimension  and then for used dimensions in pivot table to use:

- for country :   =if (DummyDim<>1, 'SubTotal', pick(DummyDim,Country))

- for region:  =if(DummyDim=1, RegionName, Country)

this is the result:

clipboard_image_0.png