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?