Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

General Total Column in Pivot Table

Good afternoon,

I have a pivot table which include 3 column (called A, B, C) dimensions for october, again the same three dimensions for november and again for december. I would like to add a grand total at the end (at right side of december) with the sum of A, B and C. I suppose it is very easy (Is easy in excel) but I can not find the way to do. Can any body help me?

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: General Total Column in Pivot Table

You can use an expression to sum everything and then use 'Show Partial Sums' to see the grand total. See attached.

View solution in original post

4 Replies
Highlighted
Not applicable

Re: General Total Column in Pivot Table

You can use an expression to sum everything and then use 'Show Partial Sums' to see the grand total. See attached.

View solution in original post

Highlighted
Not applicable

Re: General Total Column in Pivot Table

You are right, thank you.

Highlighted
Contributor III
Contributor III

Re: General Total Column in Pivot Table

A possible alternative:

Chart Properties -> Presentation-> Dimensions and
Expressions. The list box lists both expressions and dimensions. Select the
dimension you would like everything totalled according to and then check the “Show
Partial Sums” option just beneath.

Highlighted
Contributor III
Contributor III

Re: General Total Column in Pivot Table

Thanks Orson,

A very helpful insight there.