I have source film. Column A: Vendor \ Column B: Employee / Column C: Hours Planned
I have created a pivot table.
Row: Vendor then Employee
Values: Hours Planned
I have the pivot table filtered by vendor to only show vendor A. Now, I want to filter the employees within Vendor A. However when I go to filter the employees, I get a list with all the employees from all vendors.
How do I filter to show only employees from Vendor A when I initially filtered to show Vendor A.
Thanks,
Bookmarks