Hello all,

Your expert opinion is much appreciated here. I have multiple pivots on the same page, all pointing towards the same dataset. It has Name (Row label), Years(column labels), and sum of sales. The column labels are for two years (2015, 2016). I just wanted to exclude all the names who has not done any sales in 2016. I can exclude those rows in the dataset but this is not possible for various reasons and I would like to know if there is a way to do it in excel please.

I tried applying Autofilter option for the first pivot. It works but unfortunately, 'Autofilter' only works for the first two pivots and it does filter the data. However, for some reason, the 'Filter' option under 'Data' is grayed out for other pivots. I am getting 'Clear' and 'Reapply' option for other pivots. I am not sure why?

When I remove the filter from the first first pivot, the first two pivots go back to normal. I am then able to apply filters for other pivots.

So in summary, I can only apply filters for the one or the other pivot but I want to filter the blanks for all pivots. Any help is much appreciated.

I have created charts based on these pivots and if I can hide the blank or zero values in the chart, I am happy with that option too.

Many thanks