I have a list of parts and for each part the plant it is located at. So I have part 1 that is at plant A, B, and C. Part 2 is at plant A and B. Part 3 is at plant A and C. I want to filter my pivot table to show all the parts that are at plant B, but I want to also be able to see that part 1 is also at plants A and C and part 2 is also at plant A. Right now, when I filter by plant, it shows me parts 1 and 2, but I can't figure out how to get it to show the other plants as well that parts 1 and 2 are at.