Forum Discussion
Petersonne
4 years agoNew Member
How can I keep observations without specific value?
Hi, I'm trying to make a table, where the user can filter observations without a specific value. For example, let's say the user wants to focus on companies that does not produce apples and this is the dataset:
| Company | Products |
| A | Apple |
| B | Apple, Banana |
| C | Banana |
With a slicer I can choose companies that produce bananas, but that means company B and C remain in the table - I want to keep only C.
I don't want to give users access to all the filters. And since I have 30 "products" I hope to avoid create dummies for Apple, Banana, .... Is there a smarter way?
2 Replies
- Greg_DecklerCommunity Champion
- PetersonneNew Member
Thank you Greg, that is exactly what I was looking for. I've been looking for that quite some time!