Is there a way to do an advanced filter in a pivot. Linked below is a limited sample of what I am doing.
On sheet 2 is the pivot, what I am trying to do is if I have a list of say 40 different employee ID's I do I filter to only see those without having to manually check each employee id. The file attached is stripped down and only has about 6 for testing purposes. For testing if I only want to see employee id # 555555 and 222222 and 777777
how would I do that without manually checking each employee if in the filter at the top. The fields on sheet 1 will always be consistent with the header column info.
The data I am working with is extremely large and I am trying to streamline the process.
https://drive.google.com/open?id=1o9...zPjAXUomHQH2ie
Bookmarks