Pivot table - Slicer question

[sfitzpat11]

Hello, I need help with a pivot table to compare year to date sales between two different years. My data is arranged as follows:
* Column A contains the different products
* Column B contains the year of the sale
* Column C contains the country the product was sold to
* Column D contains January sales and E for February sales and so on
For the pivot table I want the 1st column to contain the product. The second column to be the first year and the third column to be the second year based on what I select from the Year slicer. I want the sales total for those years to be based on the months that I select but I cannot figure out how to created the slicer for the months since each month has its own column of data. I have been able to create this but only if I put the month field into the "Values". I want to do this via a slicer and I also do not want to display the monthly sales in the PT, only the totals. Please help.

 

[mrshl9898]

You'll need to reorganise the data so you have a column for month name and a single column for sales.

Then just have Product in Rows, Year in Columns and Sales in Values and add the 2 slicers.

 

[sandy666]

First Power Query to get table for Pivot

Source						Result TBL
Products	Year	Country	January	February		Products	Year	Country	Month	Value
item1	2018	France	22	45		item1	2018	France	January	22
item2	2919	Belgium	34	40		item1	2018	France	February	45
item3	2020	Germany	65	66		item2	2919	Belgium	January	34
item4	2018	Spain	91	19		item2	2919	Belgium	February	40
						item3	2020	Germany	January	65
						item3	2020	Germany	February	66
						item4	2018	Spain	January	91
						item4	2018	Spain	February	19

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    UOSC = Table.Unpivot(Source, {"January", "February"}, "Month", "Value")
in
    UOSC

then Pivot with a Slicer

Green table is to show only how it looks but it's not necessary load this table into the sheet
To create Pivot Table you can use transformed table directly from the Query of PQ