'Excel Filters - show only relevant values in the filter

Lets say i have two filters in an excel pivot table.

Both would initially display all values in the selected range for the filter column.

When i select a couple of values only in filter 1, the filter 2 still continues to display all values in that's particular filter's column in the selected range in base data.

What i want to do is when a certain value is selected in one filter, the second filter automatically reloads to show only values relevant to the values selected in filter 1.

Any help or workaround would be appreciated.

Thanks

Solution 1:^[1]

Try to to click right mouse on the table and choose PivotTable options, then go to 'Data' tab, and then choose 'None' under: Number of items to retain per field. i think this should solve the problem.

Solution 2:^[2]

Adding slicers instead of normal dropdown filters solves this problem. Because in slicers non-available options are greyed out.

Solution 3:^[3]

Right click on the slicer, select 'slicer settings' choose 'hide items with no data'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	erezlale
Solution 2	MGLondon
Solution 3	Daniel Fedha

'Excel Filters - show only relevant values in the filter

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]

Solution 3:^[3]