I have a dashboard containing two sheets. I'd like to create a filter where upon selecting a single option in the filter on the dashboard both sheets will change.
Selecting "Canyon Heights" in the filter will populate both sheets that pertain to Canyon Heights.
Selecting "Zona Rio" in the filter will populate both sheets that pertain to Zona Rio.
Both sheets have multiple dimensions & metrics.
Once the filter is created, I know how to apply it to the dashboard. It's creating the filter I have an issue with.
Put the filter on one sheet. Right click on the filter and select "Apply to". You can pick individual sheets, or all sheets used by that data source. Then one filter controls both sheets.