On a dashboard, I am using a sheet as a filter for other sheets.
On Dashboard Actions, there is an option to show/exclude values on the target sheets when clearing a selection. Is there a way to only show the selection on the source sheet? Right now, it highlights the selection, and other values are greyed out. I want to only show the highlighted selection, and hide the other values.
I know it is possible to right click, and select "keep only" on the menu. Is there a way to do the "keep only" automatically when selecting the value, without extra clicks?