I'm struggling to make two filters on my sheet to work together.
There are two filters for a table - first is a LOCATION(single value dropdown) filter and second one is DOMAIN(multi value dropdown) filter.The scenario is...
1. When a user selects any location item in the location list, the Domain list is forced/reset to "All".
2. When a user selects any domain item in the domain list, the Location list is forced/reset to "All"
How can I bind the filters together to work like that?
Any help would be appreciated
Try adding filters to the context.