I would like to do a cumulative count over time on some records. However I want the count to start at a specific amount (leftovers from previous month not included in data) for example start at 50.
With the following data:
| Rep | Sale Date |
|---|---|
| Bill | 6/1/24 |
| Jim | 6/1/24 |
| Bob | 6/3/24 |
The result of the count should be something similar to:
| Sale Date | Count |
|---|---|
| 6/1/24 | 52 |
| 6/2/24 | 52 |
| 6/3/24 | 53 |
I tried just adding 50 to the column but that gave 50 + whatever the count was from that individual date as opposed to 50 + cumulative sum up until that date (using the above data it gave a result of: 52, 50, 51).