1 Reply Latest reply on Dec 3, 2018 11:07 AM by patrick.byrne.0

    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:



      But the full data view in the drill down shows:




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


      Thanks in advance,