jmuffintop
New Member
- Joined
- Jun 20, 2018
- Messages
- 1
I am trying to calculate a live sales comp for 2017/2018.
In order to do the basic comp calculation, I need to sum 2017 sales up to the last corresponding sales input line for 2018. In this example it would be 2000. If I entered sales for 6/4/2018, the new aggregate sum for 2017 would be 2500. Any idea how to accomplish this?
<tbody>
</tbody>-
In order to do the basic comp calculation, I need to sum 2017 sales up to the last corresponding sales input line for 2018. In this example it would be 2000. If I entered sales for 6/4/2018, the new aggregate sum for 2017 would be 2500. Any idea how to accomplish this?
Day | Date | Sales | Day | Date | Sales | |
Thurs | 6/1/2017 | 500 | Thurs | 5/31/2018 | 700 | |
Fri | 6/2/2017 | 500 | Fri | 6/1/2018 | 700 | |
Sat | 6/3/2017 | 500 | Sat | 6/2/2018 | 700 | |
Sun | 6/4/2017 | 500 | Sun | 6/3/2018 | 700 | |
Mon | 6/5/2017 | 500 | Mon | 6/4/2018 | - | |
Tues | 6/6/2017 | 500 | Tues | 6/5/2018 | - | |
Weds | 6/7/2017 | 500 | Weds | 6/6/2018 | - | |
Thurs | 6/8/2017 | 500 | Thurs | 6/7/2018 | - | |
Fri | 6/9/2017 | 500 | Fri | 6/8/2018 | - |
<tbody>
</tbody>