1 of 1 people found this helpful
Yes we can do it by using "Relevant values " option.
For an Example
1) 1 have create a report with Market, state columns & Added Quick filters for both columns Market, state.
2) In the Hierarchy wise Market -> State. (Just Information)
3) Click on Arrow symbol of "State", & select related values.
And how to create this when the number of quick filters is more than 2? Suppose the hierarchy as
Country ->State ->City. So selecting a country should affect the quick filters for State but not vice-versa and similarly selecting a State should affect City quick filter but not the other way around.
Ashish, as far as I know, as long as you select 'only show relevant values on the city will still work. Just make sure to add city to the hierarchy
I hope this helps,