I’m wondering how would I be able to filter out groups that don’t contain a specific row. I’m currently doing an audit on some of our data and this would be very helpful to see which groups are missing rows, so I may verify and record them as such.
My issue is this. Without filtering, I have grouped up products by whichever category currently has them in stock. Now, I want to find out which Category does not have Product 1.
What I’ve done is to Filter by Where Product does not contain Product 1 . And my expected output is to only show Category 2 , which does not have Product 1 in it.
However, doing this kind of filter also returns Category 1, which has both Product 1 and 2. How can I filter it out so it will only return groups that do not have Product 1?