Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If you want running totals for each group, just take total out like:
rangesum(above(In - Out, 0, rowno()))
Used this formula:
rangesum(above(total In - Out, 0, rowno(total)))
Please find attached.
Hope this helps!
If you want running totals for each group, just take total out like:
rangesum(above(In - Out, 0, rowno()))
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?
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?
Thanks Jerem