Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
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.

4 Replies
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.

Not applicable

Re: General Total Column in Pivot Table

You are right, thank you.

Highlighted
O11235
New 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.

admin1
New Contributor III

Re: General Total Column in Pivot Table

Thanks Orson,

A very helpful insight there.