Pivot Table - Only show the relevant values in rest of filters based on the select

Hello everyone,

I want to create a pivot table in which when I select a a value in Filter 1, I want Filter 2, 3, etc... to only show the values related to Filter 1 instead of showing a whole list where there is no data.
In other words, when a certain value is selected in Filter 1, the rest of the filters automatically show only values to be able to select relevant to Filter 1. Similar to what slicers do but in the pivot table.

Example:
Filter 1 (Brand) - BMW selected
Filter 2 (Country) - Only CA, US, MX are relevant to BMW therefore these countries should be only possibilities and views to select, instead of showing the whole world wide countries.

Thanks for your feedback, let me know if this is possible to do.
D

Hi dflak,

I'm trying to create a tool to compare the overall value of an specific model vs. the similar model of the competition. Using car brands as an example Mazda 3 2018 vs Civic 2018, they have similar characteristics but some features differentiate both models, this difference in configuration gives a value/grade to the product.

Slicers are a good option to achieve this, however, the down side is that I would need to create two sets of each slicer making the dashboard look crumbled with many duplicated slicers and most importantly using this method would make the user need to drag down the list with more than 30 features to find what they're looking for vs. being able to do a 'search' just as pivot tables allows when the drop down for filters is clicked.

My thoughts in achieving this was about having two different pivot tables described in the opening post (Selecting a Filter in Filter 1, will only show specific filters in the rest of the filters related to Filter 1), that way the users could have a much cleaner tool vs. using slicers.

I don't know if there is a way to accomplish this but please let me know your comments.

Thank you for your time,
D