Filter with "OR"

[Surname]

Hi guys, 

I have follow data set: 

I would like to filter doctors who has choosen Product A or Product B or Product C. Which formula should I use? 

[DataBlender · Accepted solution]

Hi @Surname

The following code will get you the result you want. Enter into the expression box of the filter tool after choosing the 'custom filter' radio button

[Product A] = 1
OR
[Product B] = 1
OR 
[Product C] = 1

[MarqueeCrew · Accepted solution]

Or you could use:

Max([product a],[product b],[product c]) == 1