Discussion Board for collaboration related to QlikView App Development.
How can I get the total for each dimension value in the pivot table? Currently when I enable the partial sum, I can only get the total value but not the total by each dimension value. (Please see the example below)
Then you can just drag the Region-label with your mouse to a position above the Type-label. This way you rearrange the Pivot Table to give you exactly what you ask for: One total for each Country and a Grand Total for everything.
Enrique's solution should work perfectly well for what you ask for - just do the little mouse adjustment.
If you have Limited Region then you have remove Region Field from dimension tab
and add different expression for each Region then only you will get desired result.
From Test File provide by Enrique
Just Remove Region Field from Dimension tab
and Add Below three expression in Expression Tab