Filtering data using Filter tool based on multiple criteria from a column

[Vasyl11]

Hello,

When I try to filter "A1 - Sales", "A2 - Services Sales" in filter tool, I get error. See sceen. Could anyone help? Thanks

[Emil_Kos · Accepted solution]

Hi @Vasyl11,

To make in statement work you just need the name of the field + the list of items. 

Try removing contains and it should work for you. 

[Vasyl11 · Accepted solution]

Thanks a lot!

[Sntrada · Accepted solution]

If you are trying to evaluate if the US GAAP Category column contains "A1 - Sales" or "A2 - Services Sales", then your formula should be like this:

Contains ([US GAAP Category], "A1 - Sales")

OR

Contains ([US GAAP Category], "A2 - Services Sales")

If this is not what you are trying to do, please explain what you are trying to filter.