Pivot Table - Only show the relevant values in rest of filters based on the selection from Filter 1

[Dude 2 Excel Dude]

[FONT=&quot]Hello everyone,[/FONT]
[FONT=&quot]I want to create a pivot table in which when I select a a value in Filter 1, Filter 2, 3 and so on, show only the values relevant to Filter 1 instead of the whole list.[/FONT]
[FONT=&quot]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 this brand select therefore the only possibility to select, instead of showing the whole world wide countries.[/FONT]
[FONT=&quot]Thanks for your feedback, let me know if this is possible to do.
D[/FONT]

 

[Dude 2 Excel Dude]

Bump

 

[Worf]

Hello

Slicers will automatically place the relevant options on top, based on the pivot data. Do you need to change the pivot filter itself?