Apply 2 different filters to 2 different columns in pivot table...

[PP3321]

It may sound stupid question but I will try...

I have a simple pivot table with 3 columns like this:

Column A|||||||||||Column B|||||||||||Column C
(Dates) |||||||||||(Sales) |||||||||||(Sales 2016 Total)
2016 April |||||||||||100 ||||||||||| 220
2016 May |||||||||||120 ||||||||||| 220

Within the same pivot table, I want to filter:

Column B by Month
Column C by Year

Is it possible...?

 

[Chihiro]

Not in single Pivot. You will need to copy same pivot (thus retaining pivot cache), and paste to another area. You can then set filters for each.

 

[PP3321]

OK! Thanks!