Hello,
When I try to filter "A1 - Sales", "A2 - Services Sales" in filter tool, I get error. See sceen. Could anyone help? Thanks
Solved! Go to 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.
Thanks a lot!
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.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |