Pivot Table Slicer for Rows Field

[radonwilson]

Is there a way by which I can add a slicer for the pivot table ROWS FIELD?

As you can see in the pivot table I put weeks in a row field, I am looking for a way by which I can switch between months and weeks using a slicer.

Book1
	A	B	C	D	E	F	G	H
1	Date	Week	Month	Sales
2	01-01-2023	Week - 01	Jan	28641			Row Labels	Sum of Sales
3	02-01-2023	Week - 01	Jan	21232			Week - 01	2,45,342.00
4	03-01-2023	Week - 01	Jan	40932			Week - 02	2,30,052.00
5	04-01-2023	Week - 01	Jan	49990			Week - 03	2,10,740.00
6	05-01-2023	Week - 01	Jan	42946			Week - 04	2,69,864.00
7	06-01-2023	Week - 01	Jan	34171			Week - 05	3,09,985.00
8	07-01-2023	Week - 01	Jan	27430			Week - 06	2,22,395.00
9	08-01-2023	Week - 02	Jan	48838			Week - 07	2,04,699.00
10	09-01-2023	Week - 02	Jan	30762			Week - 08	2,06,470.00
11	10-01-2023	Week - 02	Jan	32328			Week - 09	2,34,893.00
12	11-01-2023	Week - 02	Jan	29508			Week - 10	2,49,543.00
13	12-01-2023	Week - 02	Jan	40648			Week - 11	2,79,034.00
14	13-01-2023	Week - 02	Jan	25422			Week - 12	2,55,326.00
15	14-01-2023	Week - 02	Jan	22546			Week - 13	1,83,373.00
16	15-01-2023	Week - 03	Jan	21572			Grand Total	31,01,716.00
17	16-01-2023	Week - 03	Jan	33064
18	17-01-2023	Week - 03	Jan	31588
19	18-01-2023	Week - 03	Jan	26168
20	19-01-2023	Week - 03	Jan	28922
21	20-01-2023	Week - 03	Jan	37660
22	21-01-2023	Week - 03	Jan	31766
23	22-01-2023	Week - 04	Jan	21856
24	23-01-2023	Week - 04	Jan	45724
25	24-01-2023	Week - 04	Jan	43725
26	25-01-2023	Week - 04	Jan	41959
27	26-01-2023	Week - 04	Jan	45223
28	27-01-2023	Week - 04	Jan	43278
29	28-01-2023	Week - 04	Jan	28099
30	29-01-2023	Week - 05	Jan	43653
31	30-01-2023	Week - 05	Jan	44521
32	31-01-2023	Week - 05	Jan	44660
33	01-02-2023	Week - 05	Feb	47041
34	02-02-2023	Week - 05	Feb	44496
35	03-02-2023	Week - 05	Feb	42535
36	04-02-2023	Week - 05	Feb	43079
37	05-02-2023	Week - 06	Feb	24788
38	06-02-2023	Week - 06	Feb	20140
39	07-02-2023	Week - 06	Feb	43805
40	08-02-2023	Week - 06	Feb	20228
41	09-02-2023	Week - 06	Feb	41249
42	10-02-2023	Week - 06	Feb	26937
43	11-02-2023	Week - 06	Feb	45248
44	12-02-2023	Week - 07	Feb	28155
45	13-02-2023	Week - 07	Feb	28670
46	14-02-2023	Week - 07	Feb	20984
47	15-02-2023	Week - 07	Feb	44510
48	16-02-2023	Week - 07	Feb	24378
49	17-02-2023	Week - 07	Feb	30446
50	18-02-2023	Week - 07	Feb	27556
51	19-02-2023	Week - 08	Feb	23307
52	20-02-2023	Week - 08	Feb	28109
53	21-02-2023	Week - 08	Feb	26271
54	22-02-2023	Week - 08	Feb	40875
55	23-02-2023	Week - 08	Feb	27831
56	24-02-2023	Week - 08	Feb	26053
57	25-02-2023	Week - 08	Feb	34024
58	26-02-2023	Week - 09	Feb	48242
59	27-02-2023	Week - 09	Feb	35165
60	28-02-2023	Week - 09	Feb	35374
61	01-03-2023	Week - 09	Mar	48708
62	02-03-2023	Week - 09	Mar	27238
63	03-03-2023	Week - 09	Mar	20019
64	04-03-2023	Week - 09	Mar	20147
65	05-03-2023	Week - 10	Mar	39942
66	06-03-2023	Week - 10	Mar	36845
67	07-03-2023	Week - 10	Mar	28798
68	08-03-2023	Week - 10	Mar	39438
69	09-03-2023	Week - 10	Mar	47166
70	10-03-2023	Week - 10	Mar	29653
71	11-03-2023	Week - 10	Mar	27701
72	12-03-2023	Week - 11	Mar	43263
73	13-03-2023	Week - 11	Mar	39185
74	14-03-2023	Week - 11	Mar	23556
75	15-03-2023	Week - 11	Mar	46019
76	16-03-2023	Week - 11	Mar	45616
77	17-03-2023	Week - 11	Mar	41415
78	18-03-2023	Week - 11	Mar	39980
79	19-03-2023	Week - 12	Mar	45027
80	20-03-2023	Week - 12	Mar	29631
81	21-03-2023	Week - 12	Mar	22717
82	22-03-2023	Week - 12	Mar	46373
83	23-03-2023	Week - 12	Mar	37210
84	24-03-2023	Week - 12	Mar	30209
85	25-03-2023	Week - 12	Mar	44159
86	26-03-2023	Week - 13	Mar	21719
87	27-03-2023	Week - 13	Mar	21835
88	28-03-2023	Week - 13	Mar	20581
89	29-03-2023	Week - 13	Mar	37063
90	30-03-2023	Week - 13	Mar	35444
91	31-03-2023	Week - 13	Mar	46731
Sheet1

Cell Formulas
Range	Formula
B2:B91	B2	="Week - "&TEXT(WEEKNUM([@Date],1),"00")
C2:C91	C2	=TEXT([@Date],"MMM")