I have one requirement, I have 2 Region(America,Asia) and 2 SubRegion(NewYork,India) Tables If I click on 'America' Region table then it should select America in Region and If i click on Asia Table it should select Asia in Filter.
It will same for Sub Region Tables also. I tried in many ways but getting partial results.
Is there a way to pass values based on Chart click? I heard that it's possible with Macros but I'm very new to Macros.