Running partial sums

[Anonymous]

Colleagues, good day!

Anyone knows, how to apply accumulative format to the Partial sums in pivot table?

so in the second column i need to get not 54 but 6779+54=6833.

and the same to the last column..

Thanks.

[techvarun · Accepted solution]

Try this '

=RangeSum(Before(TOTAL Sum(Sales), 0, ColumnNo(TOTAL)))

[techvarun]

I think it is not possible to alter the partial sum values alone.

[Anonymous]

perfect!

thanks.