bluetaurean
Member
I have a pivot table with 4 different page filters. How can the filters be reset to show data based on what is selected in the other page filters.
Example
1st filter is Country - say India, US, UAE
2nd filter is states within the respective country - Maharashtram, MP etc for India, dubai, abudhabi etc for UAE and so on.
When i select "India" in the first filter, the 2nd filter must show only states relevant to "India" however instead it show all the states for all the countries.
Is there a solution to this?
Example
1st filter is Country - say India, US, UAE
2nd filter is states within the respective country - Maharashtram, MP etc for India, dubai, abudhabi etc for UAE and so on.
When i select "India" in the first filter, the 2nd filter must show only states relevant to "India" however instead it show all the states for all the countries.
Is there a solution to this?