1
I have a row of years 2016, 2017, 2018, 2019
. And each row there is a value, with some no value. And some of them, all of the year have a value. I want to create a pivot table with a slicer that can pinpoint the year that I want to see.
The row before this is Location, customer, Product. For those, I can easily make a slicer in Pivot. But for the years I do not know how.
I want to make another slicer but for years only.
Any ideas as to how to do this?
Sample data would help, perhaps a screenshot..? – Alex M – 2019-04-11T20:45:45.080
1Yes, I just uploaded a picture. – Tom – 2019-04-12T12:41:11.683
While create Slicer, Excel asks to select Column to use as Slicer,, so that you can say value in Row or Column can be used as Slicer ro PT!! – Rajesh S – 2019-04-13T09:03:55.667