Applying Date Filter after calulating cumulative

[h_prakash]

Hi Experts,

I have a flowing requirement where I need to show last three months data after calculating cumulative.

Data is like this and I am looking for from end soultion.

I have calculated cumulative amount using Rangesum(above(total Sum( Amount) , 0, RowNo(Total))).

Date	Amount	Cumulative Amount
Jan-21	10	10
Feb-21	20	30
Mar-21	30	60
Apr-21	40	100
May-21	50	150
Jun-21	60	210
Jul-21	70	280
Aug-21	80	360
Sep-21	90	450
Oct-21	100	550
Nov-21	110	660
Dec-21	120	780
Jan-22	130	910
Feb-22	140	1050
Mar-22	150	1200
Apr-22	160	1360

and I want Data to look like 

Date	Amount	Cumulative Amount
Jan-22	130	910
Feb-22	140	1050
Mar-22	150	1200
Apr-22	160	1360

Any help is appreciated.

Thanks

Hari

[h_prakash]

Hi Vineeth,

Your expression is working perfectly. In Actual Data I have some missing dates so I have used master calendar. So if I use regular Cumulative expression the running total is showing values for the missing dates. But when I use your expression it showing only for the dates it has.

[h_prakash]

It is working Vineeth. Thank you so much.