I have a report where I have a country, state, and cities.
When I am adding a filter on these 3 dimensions all values are irrespective of what options selected in the country or states. Can I make this something like when country A is selected only states related to A should be shown and the same for others?
This can be resolved by selecting to show “only relevant values” in the state and city filter like below-
