6 Replies Latest reply on Jul 18, 2013 2:03 PM by Marc Fernandes

    Filter without affecting results, across multiple sheets

    Marc Fernandes

      I'm using this technique to be able to filter a date range for display purposes but not allow it to affect the data:

      1. Filter Without Affecting Results

       

      I want to use this filter to affect all four sheets on this dashboard which each use the same date field on the columns shelf.  For the othe quick filters shown, I've gotten by using the "Apply to Worksheets" option to apply the filter to multiple sheets.  However, using this technique above, I am not given that option to apply to other worksheets when I click the arrow on the quick filter, and I'm having trouble finding a workaround to allow me to apply this to multiple sheets.  As of now, the quick filter on the dashboard will only filter one sheet and not the other three, as shown.  Any ideas on how I can get this to work?

       

      Untitled.png