How can I do this cumulative?

[Romano_odK]

Good morning,
In the added sheet I got some sales from a few years. I want to achieve that I can see cumulative month over month of the last year. So February 2023 should look at the same month last year. Also a year over year would be great. What I can I do to achieve this, sure I guess a pivot table is one of the options. What should be my best approach and how?

Thank you for your time,

Romano

Omzet debiteuren 100 1.13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
2	Date	Customer	Quantity	Amount			Customer	2022	2023	January	February	March	April	May	June	July	August	September	October	November	December
3	13/07/2021 16:55	Piet Voorschoten	20	315,81			Piet Voorschoten
4	13/07/2021 16:55	Piet Voorschoten	1	120,7			Schilder Nederland
5	17/06/2021 16:30	Piet Voorschoten	12	370,84
6	19/11/2021 12:02	Piet Voorschoten	40	348
7	25/02/2022 14:50	Piet Voorschoten	12	439,52
8	10/03/2022 16:26	Piet Voorschoten	1	69,61
9	19/11/2021 12:02	Piet Voorschoten	2	106,77
10	25/02/2022 14:50	Piet Voorschoten	80	284,59
11	16/05/2022 15:54	Piet Voorschoten	20	356,71
12	16/05/2022 15:54	Piet Voorschoten	20	325,49
13	16/05/2022 15:54	Piet Voorschoten	20	356,71
14	16/05/2022 15:54	Piet Voorschoten	20	325,49
15	08/02/2022 10:23	Piet Voorschoten	10	162,75
16	25/02/2022 14:50	Piet Voorschoten	20	356,71
17	13/01/2022 08:34	Piet Voorschoten	10	40,17
18	01/03/2021 15:58	Schilder Nederland	20	94,86
19	29/06/2020 08:18	Schilder Nederland	25	331,54
20	29/06/2020 08:18	Schilder Nederland	5	60,98
21	07/12/2020 08:09	Schilder Nederland	10	132,62
22	07/12/2020 08:09	Schilder Nederland	5	60,98
23	11/12/2020 13:42	Schilder Nederland	30	121,97
24	15/12/2020 16:48	Schilder Nederland	20	79,13
25	30/03/2021 16:42	Schilder Nederland	30	121,97
26	01/04/2021 16:39	Schilder Nederland	20	94,86
27	01/04/2021 16:39	Schilder Nederland	20	57,35
28	05/02/2021 15:04	Schilder Nederland	15	198,92
29	05/02/2021 15:04	Schilder Nederland	5	60,98
30	05/02/2021 15:04	Schilder Nederland	20	144,96
31	08/10/2020 16:55	Schilder Nederland	12	269,79
32	08/10/2020 16:55	Schilder Nederland	30	80,37
33	08/07/2020 07:59	Schilder Nederland	5	33,82
34	15/02/2021 15:54	Schilder Nederland	20	66,55
35	01/03/2021 15:58	Schilder Nederland	20	94,86
36	29/06/2020 08:18	Schilder Nederland	25	331,54
37	29/06/2020 08:18	Schilder Nederland	5	60,98
38	07/12/2020 08:09	Schilder Nederland	10	132,62
39	07/12/2020 08:09	Schilder Nederland	5	60,98
40	11/12/2020 13:42	Schilder Nederland	30	121,97
41	15/12/2020 16:48	Schilder Nederland	20	79,13
42	30/03/2021 16:42	Schilder Nederland	30	121,97
43	01/04/2021 16:39	Schilder Nederland	20	94,86
44	01/04/2021 16:39	Schilder Nederland	20	57,35
45	05/02/2021 15:04	Schilder Nederland	15	198,92
46	05/02/2021 15:04	Schilder Nederland	5	60,98
47	05/02/2021 15:04	Schilder Nederland	20	144,96
48	08/10/2020 16:55	Schilder Nederland	12	269,79
49	08/10/2020 16:55	Schilder Nederland	30	80,37
50	08/07/2020 07:59	Schilder Nederland	5	33,82
51	15/02/2021 15:54	Schilder Nederland	20	66,55
Sheet1

 

[Peter_SSs]

I'm not certain what you mean. Can you work out the results manually for that sample data and enter them in the relevant cells and re-post the sample?