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