Filtering 2 columns in pivot table using different values.

[INN]

Hi
I created a pivot table which shows Items as Rows and Total as Values. I inserted Total as another Values in pivot table. I want 2 columns as Values in pivot table so I can filter them. One to show Total for 2022 and another one from 2021. Is that possible? Right now both columns change when I use Year as a filter. But that what I do not want. I want one to show 2021 year and another one to show 2022 year. Thank you very much.

 

[Alex Blakenburg]

Is the below what you want to finish up with ?
Show me your pivot table navigation pane. Mine is at the bottom.
If you only have date and not Years in your field list, do you know how to set up grouping for your date field ?

20221114 Pivot Table with Slicer INN.xlsx
	A	B	C	D	E	F	G	H	I
1	Date	SalesRep	Item	Region	Total
2	8/05/2021	Linda	A	East	20
3	7/07/2021	Tao	D	Central	16
4	11/05/2021	Raj	C	West	105		Sum of Total	Years
5	11/03/2021	Raj	C	West	75		Item	2021	2022
6	10/04/2021	Tao	D	Central	24		A	60	110
7	17/03/2022	Tao	D	Central	56		C	180
8	5/12/2022	Linda	A	East	70		D	40	80
9	3/06/2021	Linda	A	East	40		E		65
10	2/09/2022	Linda	A	East	40		Grand Total	280	255
11	30/06/2022	Bob	E	East	65
12	30/06/2022	Tao	D	Central	24
Sheet1

 

[INN]

Yes, that is what I want! Yes I know how to get the year. Many thanks indeed for your help.

 

[Alex Blakenburg]

You're welcome. Phew. Glad you know how to do the year that was going to be the hardest part to explain