Find ALL previous days sales

[gireesh1216]

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

[Frank_Hartmann · Accepted solution]

Dimension = ID

Expression1 = sum(SALES)

Expression2 = Rangesum(above(sum(SALES),0,RowNo()))

[MarcoWedel]

Hi,

you could also use the standard "full accumulation" option in your chart properties:

hope this helps

regards

Marco