Filtering by OR
Suppose I have a table like this
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.
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.