Hello!
Currently, the filter control options avaiable for Quick Filter are:
Match value
Single select
Multi-select
Is there a way to use these filter controls together? For example, I may have two columns with the following values:
Name Pets
Ann Cat, Dog, Bird, Reptile
Ben Dog, Bird
Kate Bird, Reptile
Tom Cat
Will Cat, Bird
I added a Match value filter to find all rows that contains "Cat" in Pets, but I only want to select a few of the resulting matches. For example, the match value filter returns:
Cat, Dog, Bird, Reptile
Cat
Cat, Bird
But I only want to select Cat and Card, Bird. Am I able to do this?
I would just do Multi-Select for a simple dataset (such as this example) but unfortunately my dataset may contains up to 100 unique values.