How to enable multiple dependent Slicer

[harinn777]

Actually, I was facing an issue with one of my models and wanted your help.

Just attaching a dummy for your reference. I have a table with multiple OEM for each country. I want to have just 2 slicers one each for OEM and Country (inter-related). I mean when i select country, only the specific OEM active in the particular country should get activated and vice-versa. Could you please help me with a way out.
Is there any way that i can get the slicer from table 1 to do this? Since table 1 has different OEM for different countries, i am not able to make an OEM slicer from table 1.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Slicer issue
and Slicer issue
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.