5 Replies Latest reply: Jun 16, 2014 4:04 PM by Goutham Kandukuri

# Running total/Cumulative in pivot Chart

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.

• ###### Re: Running total/Cumulative in pivot Chart

Used this formula:

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

Hope this helps!

• ###### Re: Running total/Cumulative in pivot Chart

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

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

• ###### Re: Running total/Cumulative in pivot Chart

Thanks Jerem

• ###### Re: Running total/Cumulative in pivot Chart

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?

• ###### Re: Running total/Cumulative in pivot Chart

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?