Pivot Tables - Question about slicers

[scoscione]

Hello all,

I have a database which I need to convert and summarize as a pivot table. Until there all fine, but my issue is the data is organized in columns, meaning each column represent a month.
I wanted to have a slicer that is capable of automatically change the month - in this case the column in which the data is being read. Does any one know if this is possible

Vendor	Country	Jan	Feb	Mar
Charles	USA	100	110	120
Lin	China	500	100	90

<tbody>
</tbody>

So basically once, the table above is summarized in a pivot I have to manually select which months am I reading, while I wanted to have a slicer that automatically updated which column is the data being read.

Thanks,
S

 

[SpillerBD]

Excel is based on columnar/transactional data. Your data confounds that method already being in a "Pivot Table" like layout. Your data needs to un-pivoted first.
You can find macros to perform the unpivot as well as a method using the PivotTable wizard.
However, if you have Excel 2016, there is a new feature for everyone called Get & Transform which has a Unpivot capability to it. Get & Transform was Power Query in previous Pro+ and Enterprise versions of Excel.