2 Replies Latest reply on Feb 8, 2019 10:25 AM by Ray Lam

    Dashboard Action - Hide Unselected Data In Source Sheet

    Ray Lam

      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?