I'm designing a dashboard with several worksheets and would like to use one of the worksheets as a global filter. The data in that worksheet is already filtered to remove some outliers.
When I click to treat the worksheet as a filter, the dashboard updates to show the unfiltered version of that spreadsheet (e.g. including outliers). Is there any way around this issue? I supposed I could filter my underlying data at the source, but I'd rather not do that unless absolutely necessary. Thanks in advance for any help you can provide!
Try duplicating the filter on the worksheet, use the copy to filter the outliers. Then when you set up the Dashboard action, use 'Selected Fields' option to exclude the copy from the filter action. Post a workbook and I'll set it up for you.