General Total Column in Pivot Table

[#1]

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?

[#2 · Accepted solution]

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

[#3]

You are right, thank you.

[O11235]

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.

[Anonymous]

Thanks Orson,

A very helpful insight there.