Cummulative sum expression

[johnjustus]

All,

I would like to calculate Cumulative total for the below sample data in the front end.

Can some one please help me out with the correct expression? Thanks

Product ID         Sales    Cumulative Total

A12                          20             20

A13                         30              50

A14                        40               70

A15                        50              90

[Vegar · Accepted solution]

Try an expression like this:

sum( aggr( rangesum( above( sum(Sales),0,2) ),[Product ID]))

[johnjustus]

Perfect - Thanks