Filter a enum type column

I have a column called “Type” with 10 different choices (example: Red, green , Yellow, blue, orange…)
If in the slice, i want to select only Type Red and Type Yellow, what shall I write in the filter? Sorry but I tried different hints but no one is working. Thank you … I am really newbie

Solved Solved
0 3 237
1 ACCEPTED SOLUTION

To display rows of only customers whose favorite color is red or yellow:

IN([Colour], {"Red", "Yellow"})

View solution in original post

3 REPLIES 3

Steve
Platinum 4
Platinum 4

Let me explain better: the column name is “Colour” , in the rows are different colours (red , blue, green, black, yellow, etc…) and there is a column with the name of the customers, which everyone has choosenhis favourite colour. To extrapolate only the name of the customers whose favourite colour is RED and Yellow, the function in the filter how should I write it?
IN (RED, Yellow [Colour]) or something like this?

To display rows of only customers whose favorite color is red or yellow:

IN([Colour], {"Red", "Yellow"})
Top Labels in this Space