Pivot Table Filtering Question

[Mr_Phil]

Hi everyone. If I create a pivot table and filter on location then technician shouldn't the output be techs that are specific to the location? That's the output when I apply autofilters to the data table. But it doesn't appear to be doing that on the main pivot table. Any ideas on what I could be doing wrong? The point of the filters is to reduce the number of technicians to a manageable level and generate daily pick sheets. Thanks for looking and any insight. Happy Holidays to all and a very Merry Christmas if you observe it.

 

[Mr_Phil]

I found the answer after a LOT of googling. The filters are independent of each other. There is a workaround but it requires VBA and I am trying to avod that if possible in this workbook.