Adding row(1) with previous row(2)

[#1]

Object	10	2	4	8	10
Accumulation	10	12	16	24	34

How can i calculate in this way using pivot table? Both 'Object' and 'Accumulation' are expression. Any suggestions on what expressions to use?

January	February	March	1st quarter
10	11	1	23
10	21	22	---

And, how can i derived in such a way every quarter, the second row will be null?

[Gysbert_Wassenaar]

Try: rangesum(above(total sum(Object),0,rowno(total)))

depending on the layout of your table you may need to use the before() function instead of above()

[#3]

RangeSum(Above(sum(Object),0, rowno()))

[#4]

Thanks for all of your reply. But I'm having 'Bad Field Name(s): Object ' . Sorry that i forgot to state that my object is actually an expression.

[#5]

see attached file

Try to use Object field in expression

[#6]

I tried to use the field icon but its still the same. Still having the same error.

[priyav24]

PFA..

This is another way of doing the cumulative sum..

Just check the full accumulation