Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this '
=RangeSum(Before(TOTAL Sum(Sales), 0, ColumnNo(TOTAL)))
I think it is not possible to alter the partial sum values alone.
perfect!
thanks.