I have a dashboard with a large set of filters applying to different sheets. I would like to set up 3-5 scenarios which are made up of different combinations of filters and ideally link this to an action. i.e. I have pre-determined the relevant filters for Scenario A, I select Scenario A (maybe a master filter or some active object) and all filters are set to this scenario avoiding the need to set each one manually.
Initially, I thought a way around this would be to replace all filters with parameters and define scenarios with a calculated field or something but this seems unnecessarily complex.
There doesn't seem to be an obvious way to do this so I would appreciate any insight anyone has.