0 Replies Latest reply on Oct 25, 2018 8:55 AM by Brandon Griffin

    Filter applied across worksheets doesn't correctly filter underlying data

    Brandon Griffin

      I have a set of worksheets where one worksheet is the master and contains a filter allowing my clients to filter down to a single business unit.    I applied this across all worksheets by right clicking on the filter --> Selecting Apply to Worksheets --> Selected Worksheets --> Select All.

       

      The filter works perfectly when presenting the actual worksheets but it does not filter the underlying data when a user drills down:

       

      This is my example where there are two filterable units (Viking and VWLC).   I have the main sheet set to filter down to just Viking and it shows the correct 2 visits in September on the chart itself:

      Capture1.PNG

       

      But the full data view in the drill down shows:

       

      Capture2.PNG

       

      Curious as to if anyone has encountered this and has a solution?

       

      Thanks in advance,

      Brandon