Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want pivot table to show result like this
sum1 sum2
5 5
6 11
7 18
Sum2 always shows the total of all values of sum1
how it is possible?
thanks
Lavi
Try something like rangesum(sum1,above(sum1))
Or use a straight table and use the function accumulate.