Year to Date last Year in a Pivot Table

[nekthen]

I have a data table with a date field for sales in last year.
I have created a Pivot Table
I want to filter the data to only show YTD values for a year ago.
e.g. Today I want to filter dates up to 06/06/23. The tricky bit is I want this to be dynamic so it will change tomorrow to 07/06/23

 

[awoohaw]

You can use multi-select slicers:

Book1
	A	B	C
1	Date	Value
2	2023-01-01	28
3	2023-01-17	22
4	2023-02-02	23
5	2023-02-18	25
6	2023-03-06	29
7	2023-03-22	28
8	2023-04-07	25
9	2023-04-23	30
10	2023-05-09	23
11	2023-05-25	26
12	2023-06-10	25
13	2023-06-26	23
14	2023-07-12	22
15	2023-07-28	25
16	2023-08-13	29
17	2023-08-29	28
18	2023-09-14	30
19	2023-09-30	30
20	2023-10-16	30
21	2023-11-01	27
22	2023-11-17	26
23	2023-12-03	30
24	2023-12-19	25
25	2024-01-04	29
26	2024-01-20	24
27	2024-02-05	30
28	2024-02-21	25
29	2024-03-08	23
30	2024-03-24	21
31	2024-04-09	27
32	2024-04-25	21
33	2024-05-11	24
34	2024-05-27	30
35	2024-06-12	29
36	2024-06-28	25
37	2024-07-14	21
38	2024-07-30	22
39	2024-08-15	29
40	2024-08-31	25
41	2024-09-16	21
42	2024-10-02	24
43	2024-10-18	29
44	2024-11-03	24
45	2024-11-19	24
46	2024-12-05	21
47	2024-12-21	22
48
Sheet3

Cell Formulas
Range	Formula
A3:A47	A3	=A2+16