Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try an expression like this:
sum( aggr( rangesum( above( sum(Sales),0,2) ),[Product ID]))
Try an expression like this:
sum( aggr( rangesum( above( sum(Sales),0,2) ),[Product ID]))
Perfect - Thanks