Hello Smart People, I am looking to do a rolling total on a week by week. weekly revenue was derived by grouping by week .
=Aggr(sum(sales),week_of_Year)
I need to generate the expected column result broken down by week. I have used
RangeSum(Above(Total Sum(Aggr(sum(sales),week_of_Year), Rowno() without any luck. please your assistance is highly appreciated.
| Year Month | Date | Day
of Week | Weekly Rev | Expected
Weekly Rolling |
| Apr 2015 | 4/30/2015 | 4 | $0. | $499 |
| Apr 2015 | 4/29/2015 | 3 | $0. | $499 |
| Apr 2015 | 4/28/2015 | 2 | $0. | $499 |
| Apr 2015 | 4/27/2015 | 1 | $499. | $499 |
| Apr 2015 | 4/24/2015 | 4 | $0. | $499 |
| Apr 2015 | 4/23/2015 | 3 | $0. | $499 |
| Apr 2015 | 4/22/2015 | 2 | $0. | $499 |
| Apr 2015 | 4/21/2015 | 1 | $499. | $499 |
| Apr 2015 | 4/17/2015 | 5 | $0. | $0 |
| Apr 2015 | 4/16/2015 | 4 | $0. | $0 |
| Apr 2015 | 4/15/2015 | 3 | $0. | $0 |
| Apr 2015 | 4/14/2015 | 2 | $0. | $0 |
| Apr 2015 | 4/13/2015 | 1 | $0. | $0 |
| Apr 2015 | 4/10/2015 | 5 | $799. | $3,690 |
| Apr 2015 | 4/9/2015 | 4 | $0. | $2,891 |
| Apr 2015 | 4/8/2015 | 3 | $1,498. | $2,891 |
| Apr 2015 | 4/7/2015 | 2 | $894. | $1,393 |
| Apr 2015 | 4/6/2015 | 1 | $499. | $499 |
| Apr 2015 | 4/3/2015 | 2 | $0. | $0 |
| Apr 2015 | 4/2/2015 | 1 | $0. | $0 |
