Spreadsheet: 883394d1732019668-cumulative-value-graph-in-pivot-chart-cumulative-value-graph-in-pivot-chart
Sheet: Sheet1

Department | Month-Year | Product 1 | Product 2 | Product 1 Cum | Product 2 Cum |  | Using PivotTable: |  |  |  |  |  |  | Using formula:
A | 2024-01-01 00:00:00 | 4 | 0
B | 2024-01-01 00:00:00 | 0 | 0 |  |  |  | Month-Year | 2024-06-01 00:00:00
C | 2024-01-01 00:00:00 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Product 2
D | 2024-01-01 00:00:00 | 1 | 0 |  |  |  | Department | Sum of Product 1 Cum
E | 2024-01-01 00:00:00 | 0 | 1 |  |  |  | A | 10 |  |  |  |  |  | B | 1 | 0
F | 2024-01-01 00:00:00 | 0 | 1 |  |  |  | B | 1 |  |  |  |  |  | C | 1 | 7
G | 2024-01-01 00:00:00 | 0 | 0 |  |  |  | C | 1 |  |  |  |  |  | D | 2 | 2
H | 2024-01-01 00:00:00 | 0 | 0 |  |  |  | D | 2 |  |  |  |  |  | E | 2 | 17
A | 2024-02-01 00:00:00 | 4 | 1 |  |  |  | E | 2 |  |  |  |  |  | F | 0 | 6
B | 2024-02-01 00:00:00 | 1 | 0 |  |  |  | F | 0 |  |  |  |  |  | G | 1 | 0
C | 2024-02-01 00:00:00 | 0 | 1 |  |  |  | G | 1 |  |  |  |  |  | H | 2 | 1
D | 2024-02-01 00:00:00 | 0 | 2 |  |  |  | H | 2 |  |  |  |  |  | Total
E | 2024-02-01 00:00:00 | 0 | 5 |  |  |  | Grand Total | 19
F | 2024-02-01 00:00:00 | 0 | 0
G | 2024-02-01 00:00:00 | 0 | 0 |  |  |  | Added 1 helper column with the formula: =SUMIFS([Product 1],[Department],[@Department],[Month-Year],"<="&[@[Month-Year]]).
H | 2024-02-01 00:00:00 | 0 | 0 |  |  |  | And plotted PivotTable & Chart against this helper column.
A | 2024-03-01 00:00:00 | 1 | 2
B | 2024-03-01 00:00:00 | 0 | 0
C | 2024-03-01 00:00:00 | 0 | 0
D | 2024-03-01 00:00:00 | 0 | 0
E | 2024-03-01 00:00:00 | 0 | 5
F | 2024-03-01 00:00:00 | 0 | 1
G | 2024-03-01 00:00:00 | 0 | 0
H | 2024-03-01 00:00:00 | 0 | 1
A | 2024-04-01 00:00:00 | 1 | 0
B | 2024-04-01 00:00:00 | 0 | 0
C | 2024-04-01 00:00:00 | 1 | 1
D | 2024-04-01 00:00:00 | 0 | 0
E | 2024-04-01 00:00:00 | 2 | 2
F | 2024-04-01 00:00:00 | 0 | 0
G | 2024-04-01 00:00:00 | 1 | 0
H | 2024-04-01 00:00:00 | 2 | 0
A | 2024-05-01 00:00:00 | 0 | 3
B | 2024-05-01 00:00:00 | 0 | 0
C | 2024-05-01 00:00:00 | 0 | 1
D | 2024-05-01 00:00:00 | 0 | 0
E | 2024-05-01 00:00:00 | 0 | 3
F | 2024-05-01 00:00:00 | 0 | 3
G | 2024-05-01 00:00:00 | 0 | 0
H | 2024-05-01 00:00:00 | 0 | 0
A | 2024-06-01 00:00:00 | 0 | 1
B | 2024-06-01 00:00:00 | 0 | 0
C | 2024-06-01 00:00:00 | 0 | 3
D | 2024-06-01 00:00:00 | 1 | 0
E | 2024-06-01 00:00:00 | 0 | 1
F | 2024-06-01 00:00:00 | 0 | 1
G | 2024-06-01 00:00:00 | 0 | 0
H | 2024-06-01 00:00:00 | 0 | 0
A | 2024-07-01 00:00:00 | 0 | 6
B | 2024-07-01 00:00:00 | 1 | 0
C | 2024-07-01 00:00:00 | 1 | 5
D | 2024-07-01 00:00:00 | 0 | 0
E | 2024-07-01 00:00:00 | 0 | 4
F | 2024-07-01 00:00:00 | 2 | 1
G | 2024-07-01 00:00:00 | 0 | 0
H | 2024-07-01 00:00:00 | 0 | 1
A | 2024-08-01 00:00:00 | 0 | 0
B | 2024-08-01 00:00:00 | 0 | 0
C | 2024-08-01 00:00:00 | 0 | 0
D | 2024-08-01 00:00:00 | 0 | 0
E | 2024-08-01 00:00:00 | 0 | 1
F | 2024-08-01 00:00:00 | 0 | 1
G | 2024-08-01 00:00:00 | 3 | 0
H | 2024-08-01 00:00:00 | 2 | 2
A | 2024-09-01 00:00:00 | 0 | 2
B | 2024-09-01 00:00:00 | 2 | 0
C | 2024-09-01 00:00:00 | 0 | 0
D | 2024-09-01 00:00:00 | 0 | 0
E | 2024-09-01 00:00:00 | 1 | 1
F | 2024-09-01 00:00:00 | 0 | 2
G | 2024-09-01 00:00:00 | 0 | 0
H | 2024-09-01 00:00:00 | 0 | 1