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