5 Replies Latest reply on Jan 11, 2012 8:19 AM by Rocky Yost

    Date filters for multiple sheets

    Rocky Yost

      Hi all!

      Is there anyway to do the follow:

      Have a date range selector, that when changed, filters several sheets based on the selected dates.

       

      I've got 7 dashboard sheets, each with multiple charts and graphs. I'd like the selector to change what data is displayed on all the charts and graph across the 7 dashboards.

      While there are several data sources, every data source has a date field. The date field is simply called 'date' for all the sources.

       

      I've tried using filters, but they don't seem to work. If a chart or graph comes from the same source, it'll work, but it doesn't effect any other sheet.

       

      It's crazy to have to go through each sheet and update the date ranges every time!

       

       

      Thanks for your help!