Hello,
could someone please help me to create a cumulative summary of the value when on monthly basis only changes are reported?
Example below: at the beginning of 2025 (first reporting) full number of employees was reported.
Later on (on monthly basis) only changes are reported (leavers, newcomers).
Every month I would need to show the summary from the beginning of the reporting period
- e.g. for company AAA in February 1 manager in marketing (2 in Jan minus 1 in Feb).
I tried different ways, e.g. Summarize Tool and Group by, but without luck..
Thank you!!
| PERIOD | COMPANY | DEPARTMENT | ROLE | VALUE |
| 2025-01-01 | AAA | MARKETING | MANAGER | 2 |
| 2025-01-01 | AAA | MARKETING | SPECIALIST | 10 |
| 2025-01-01 | AAA | FINANCE | SPECIALIST | 8 |
| 2025-01-01 | BBB | FINANCE | JUNIOR | 20 |
| 2025-02-01 | AAA | MARKETING | MANAGER | -1 |
| 2025-02-01 | AAA | MARKETING | SPECIALIST | +3 |
| 2025-02-01 | AAA | FINANCE | SPECIALIST | -1 |
| 2025-02-01 | BBB | FINANCE | JUNIOR | 0 |
| | | | | |
