Using Superstore as an example, what if I wanted to exclude 'Standard Class' Ship Mode from all 'East' & 'West' Regions. ...but I wanted to be able to report all ship modes for the other regions.
Is there a way to do this at either the data source level or as a context filter? I have a dashboard with many calculations. I realize this can be done at the individual calc level, but I'm looking for a better way.
In case anyone is interested in this down the road, I was able to accomplish this by creating a combined field 'Ship Mode & Region'. I then filtered out what I didn't need & moved the filter to Context & applied to all using this data source. Seems to have done the trick.