Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
It is working Vineeth. Thank you so much.