My colleague tackled this last year with a blog post and crushed it. When you download that workbook that he has provided the layout and what he has done should become fairly clear. Cheers!
Thank you so much for the reply! I spent hours trying to replicate it only to realize finally why mine was not working the same way!
So - I have 17 filters set up on a "Filter Control" worksheet and then I have an action set-up to take the user to the result Dash board page.
All 17 of my filters are set up to Apply to Worksheets -> All Using this Data Source. With that selection turned on, the action to reset the filter to "All" does not work! If I turn it off and make it only Apply to This Worksheet, it works fine.
But I need it to apply to all worksheets using this data source because of how the dashboard is set up!
So, any ideas on what I can do to make this all work? Thanks so much in advance!!!