Hi Team,
I am having numbers need to be added as cumilatively. Range sum() will do that. After that i need to get average of those numbers monthly. I am having 5 years of data.
For example
In this case if i want to calculate Avg for May-17 i need to consider (72+102)/2 insted of (12+30)/2
| monthyear | Value | Range sum |
| Jan-17 | 15 | 15 |
| Feb-17 | 20 | 35 |
| Mar-17 | 25 | 60 |
| Apr-17 | 12 | 72 |
| May-17 | 30 | 102 |
How can i achieve this. Thanks in advance.
Regards,
Sadasiva
