Pivot Table Filter

[Sumit_Bhokare]

Hi Community,

I need one help on Pivot table filter.

Is there any way in pivot to show only applicable data when we select multiple filter? in simple way I need to filter data similar to filtering option available in excel file, like first need to apply filter for one column then it will show only applicable fields then when I apply another filter on another column it will show only fields available in both filters?

Thanks!

[#2]

@Sumit_Bhokare 

As variant you may use slicers hiding items with no data in slicer setting

[#3]

@SergeiBaklan fields I have in column are large number hence its difficult to use slicer. Is there any other way in pivot?

[#4]

@Sumit_Bhokare 

Sorry, have no idea