Hello everyone, I hope you are very well, I have a problem that has not worked for me at all, I need to accumulate a numeric column by group and date. The example table is the following:
GROUP | DATE | TOTAL | CUMULATIVE_BY_GROUP |
A | 01-01-2022 | 12 | 12 |
A | 02-01-2022 | 15 | 27 |
A | 03-01-2022 | 3 | 30 |
A | 04-01-2022 | 3 | 33 |
A | 05-01-2022 | 16 | 49 |
A | 06-01-2022 | 7 | 56 |
B | 01-01-2022 | 3 | 3 |
B | 02-01-2022 | 6 | 9 |
B | 03-01-2022 | 18 | 27 |
B | 04-01-2022 | 6 | 33 |
B | 05-01-2022 | 2 | 35 |
B | 06-01-2022 | 12 | 47 |
C | 01-01-2022 | 16 | 16 |
C | 02-01-2022 | 4 | 20 |
C | 03-01-2022 | 19 | 39 |
C | 04-01-2022 | 16 | 55 |
C | 05-01-2022 | 4 | 59 |
C | 06-01-2022 | 6 | 65 |
Thanks.