Amount in Total

[Former Member]

How do l get rollup total, l have following data.

May YTD Amount - 1500
June YTD Amount - 1600
July YTD Amount - 1750.

What I need is
June Actual Amount - 3100 -- (1600 plus1500)

July Actual Amount - 4700 -----(3100 plus 1600)

Aug Actual Amount - 6450 ----(4800 plus 1750).

I used relativevalue but does not rollup the amount continuously.

Thanks

[amitrathi239 · Accepted solution]

use runningsum() function.