Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
In straight table check the total mode area in the expressions tab
pls attach a small sample app
enable this for every dimension you need
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??
Hi Jebamalai,
i'm trying to get the total of the "30 day velocity"
I have one dimension and i enabled the "Show partial sums" and "Sub totals on the top".
But no result.
can you attach the screenshot of the pivot and the settings mentioned by the experts in this thread?
I did it.
But Total is not showing up.
If you have only one dimension then why do you use pivot?
Go for straight table
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