topic Re: General Total Column in Pivot Table in QlikView

General Total Column in Pivot Table

Mon, 01 Oct 2012 17:26:19 GMT

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?

Re: General Total Column in Pivot Table

Mon, 01 Oct 2012 18:28:08 GMT

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

Re: General Total Column in Pivot Table

Tue, 02 Oct 2012 07:26:12 GMT

You are right, thank you.

Re: General Total Column in Pivot Table

O11235 — Thu, 14 Aug 2014 14:17:15 GMT

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.

Re: General Total Column in Pivot Table

Anonymous — Tue, 06 Oct 2015 09:50:26 GMT

Thanks Orson,

A very helpful insight there.