Running total/Cumulative in pivot Chart

[gouthamkk]

HI,

I am trying to get cumulative total for net column, My calculation in (In - Out) + Previous Net(Running total) for each group.

I tried using Range sum and above functions, getting only the value of previous row but not as a cumulative/ running total.

If used in a straight table, by selecting Full Accumulation, i could achieve it.  But my scenario is to use a pivot table.

Request for assistance.

[jerem1234]

Used this formula:

rangesum(above(total In - Out, 0, rowno(total)))

Please find attached.

Hope this helps!

[jerem1234 · Accepted solution]

If you want running totals for each group, just take total out like:

rangesum(above(In - Out, 0, rowno()))

[gouthamkk]

Really appreciate it.

sorry to not mention, The running total hast to occur for each group, not for entire table, Is it possible to get the running total group wise?

[jerem1234]

Should be able to use:

rangesum(above(In - Out, 0, rowno()))

like I mentioned above.

If not, can you give an example of the output you want? What numbers are you expecting for your example?

[gouthamkk]

Thanks Jerem