Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi *,
I'm using a pivottable that looks like this:
How can I do a accumulate the values:.
-> 01.01.2010: 10
02.01.2010: 0
03.01.2010: 15
....
Thanks for your help.
Regards
Aloah
Oops! Do this:
rangesum(sum(Value),above(Kumulation))
You're adding the current sum(Value) to the Kumulation from the above row. The way I gave it to you the first time was only adding to the sum(Value) of the above row, which wasn't what I intended, and as you see, doesn't give the result you want.
I think this:
rangesum(sum(Value),above(sum(Value))
Hi,
with rangesum I get this 10, 0, 5.... instead of 10, 0, 15...
Oops! Do this:
rangesum(sum(Value),above(Kumulation))
You're adding the current sum(Value) to the Kumulation from the above row. The way I gave it to you the first time was only adding to the sum(Value) of the above row, which wasn't what I intended, and as you see, doesn't give the result you want.