By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| GroupNr | Name | Sum | CumSum | ResetCumSum |
|---|---|---|---|---|
| 1 | Mary | 0.00 | 0.00 | 0 |
| 1 | Jane | 179.00 | 179.00 | 179 |
| 1 | Tom | 106.00 | 285.00 | 285 |
| 1 | Joseph | 175.00 | 460.00 | 460 |
| 1 | Arthur | 253.00 | 713.00 | 253 |
| 2 | Mary | 0.00 | 0.00 | 0 |
| 2 | Jane | 365.00 | 365.00 | 365 |
| 2 | Tom | 365.00 | 730.00 | 365 |
| 2 | Joseph | 365.00 | 1095.00 | 365 |
| 2 | Arthur | 365.00 | 1460.00 | 365 |