RunningSum/Cumulative Total

Question & Answer
,
1

Hi All,

I am trying to create a calculated field that will show me the running sum/ cumulative total for each year. But, I don’t want a cumulative total from the start of that year. So, for example if in 2017 I made 5 sales, my cumulative total should be 0 for year 2017. And it should be added in 2018. The reason to do this is to show how many sales are being done in that year and how much contribution it has towards the cumulative total.

Any help would be highly appreciated

Thanks,
Akshay

image
image1674×444 37.8 KB

2

Hello @akshaym !

I would recommend using the lag function:

3

Hi @duncan,

Thank you for your help. This is exactly what I was looking for

Thanks,
Akshay

1 Like
4

@akshaym no problem at all, it’s a really useful function!