Filtering by OR

Suppose I have a table like this

Hotel Aircon Fan
A Yes No
B No Yes


Can I create a filter scheme for this table based on Aircon and Fan columns, and allow OR between them? 

For example if I select Aircon=Yes and Fan=Yes then both hotels A and B will come up? 

I don't want to use filter expression as well as add another table.

Thanks, Viet


1 Comment

If you want to flexibly choose which columns to include, use a document property that lists the columns, then a calculated column that conditionally concatenates the columns based on whether they are selected or not.

j_w - Nov 01, 2018 - 8:36am
+ Add a Comment

(2) Answers