Discussion board where members can get started with QlikView.
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]))
View solution in original post
Perfect - Thanks