My filters are not working as expected. I have this worksheet on my dashboard. I have a filter on this worksheet that displays only 10 (ss1-ss10) out of 25 columns
I use it as a filter for other worksheets.
I have a filter on this worksheet also that displays only 10 (ss1-ss10) out of 25 columns
When I click on a column in Worksheet1, it filters Worksheet2.
The problem is, when I clear the filter in Worksheet1, instead of having only 10 columns displayed in Worksheet2, I get all columns displayed.
because of this setting
Is there any way to bypass this, so that only the values defined in the filter are retained?
Try adding your filters to Context. Right click the pill in the filter box, and select Add to Context.
The trick is that you also have to add the Action Filter to Context.
See if this works,