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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot add grand total to Pivot

I would like to add a grand total to the pivot table below. But the total option is greyed out. When I convert it to a straight table totals are displayed without a problem. Does anybody has a suggestion ?

Holke

error loading image

error loading image

error loading image

1 Solution

Accepted Solutions
Not applicable
Author

pivot properties-presentation-show partial sums

View solution in original post

2 Replies
Not applicable
Author

pivot properties-presentation-show partial sums

Not applicable
Author

Pivot tables don't use Running Total. You can achieve a similar effect by using Partial Sums.

Select the first Dimension under the Presentation tab and check Partial Sums.