I have large num. of rows in a column and i'm trying to get the sum of the numbers in the column.
I tried using Subtotals>Display on top/bottom. But, no result.
Can anyone pls help me in getting the grand total of the column.
Solved! Go to Solution.
you need to select a dimension, for which you want to see the total..then select "show partial sum" for that selected dimension..see in the image..
how many dimensions , do you have in chart??
You have to check all the calculations(expressions) used in this pivot
For me it looks like you enabled only in the dimension not in the expression