Pivot table - Sum total of column - Not working

[markgraham123]

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.

[Anonymous]

pls attach a small sample app

[giakoum]

enable this for every dimension you need

[israrkhan]

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

[markgraham123]

Hi Jebamalai,

i'm trying to get the total of the "30 day velocity"

[markgraham123]

I have one dimension and i enabled the "Show partial sums" and "Sub totals on the top".

But no result.

[Anonymous]

can you attach the screenshot of the pivot and the settings mentioned by the experts in this thread?

[markgraham123]

I did it.

But Total is not showing up.

[Anonymous]

If you have only one dimension then why do you use pivot?

Go for straight table

[Anonymous]

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