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! Go to Solution.
To display rows of only customers whose favorite color is red or yellow:
IN([Colour], {"Red", "Yellow"})
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"})
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |