I have a field that has a choice list. There are 3 possible individual choices, 1NQ, 2NQ, 3NQ. It can also be a combination of any of the 3 for a total of 7. I’d like to be able to filter for the different combos, for example 1NQ 2NQ.
The normal filter dropdown is an OR filter. I’d like an AND filter. I could create a new filed where I combine the values and then filter on that… if I knew how to combine the choices into a single combo choice.
any help is appreciated