Wondering if this is possible. Wanted the moving average of the past 30 days in sales but cumulative. All of the last 30 days cumulative average. Not sure how to make the calculation. Didnt provide the books but its seems like it should be doable. I can get a moving average on a 30 day basis, but i want to try and get a sliding window for the past 30 days.
example: 1 2 3 4 5 6 7 8 9 10
5 day cumulative average would be 1+2+3+4+5 = 15, next day would be 2+3+4+5+6= 20 etc. Not sure on the Calc