Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I have a data like below:
Days | SALES |
---|---|
1 | 10 |
2 | 5 |
3 | 15 |
4 | 20 |
RESULTS:
DAYS | SALES | ALL DAYS |
---|---|---|
1 | 10 | 10 |
2 | 5 | 15(Previous days sales10+5) |
3 | 15 | 30(Previous days sales 10+5+15) same for others aswell |
4 | 20 | 50 |
Dimension = ID
Expression1 = sum(SALES)
Expression2 = Rangesum(above(sum(SALES),0,RowNo()))
Dimension = ID
Expression1 = sum(SALES)
Expression2 = Rangesum(above(sum(SALES),0,RowNo()))
Hi,
you could also use the standard "full accumulation" option in your chart properties:
hope this helps
regards
Marco