This content has been marked as final.
Show 3 replies
-
1. Re: Apply Filter from Lookup Function to All Worksheets
David Weaver Aug 25, 2016 4:53 PM (in response to Todd Moses)I'd like to try a couple things, is it possible to upload the tbwx file?
-
2. Re: Apply Filter from Lookup Function to All Worksheets
Todd Moses Aug 29, 2016 10:56 AM (in response to David Weaver)There are two worksheets.
They both have the filter, but neither will allow me to apply the filter to all worksheets using that data source.
-
LookupFilter.twbx 18.1 KB
-
-
3. Re: Apply Filter from Lookup Function to All Worksheets
Todd Moses Sep 6, 2016 10:26 AM (in response to Todd Moses)I finally solved this. Not the way I wanted it to appear, but as good as I think I'll be able to get it.
I just created two data grids, one with the additional detail field, one with a constant of "total".
Then when I set my filters, I only applied the filter to the more detailed data grid instead of the with the totals.
On my dashboard, I'm displaying both data grids, but changes in the filter don't impact the "Totals" data grid.
Like I said, not as pretty as I'd hoped for, but it got the job done.