Here is my data:
| Design ID | Color |
| 100 | Yellow |
| 100 | Green |
| 200 | Yellow |
| 200 | Blue |
I have a filter pane for "Color":
If I select Yellow, we show Design ID 100 and 200
***Below is my requirement***
I want to have a second filter called "Exclude Color":
If I select Yellow in filter filter and "Green" in second (exclude) filter, I want to be able to exclude the row where Color is Green and return just Design ID 200.
Please help me to figure this out.
