Filtering data table based on conditions of two columns

[Charlotte Price]

I have a table which I want to filter to only show rows based on some rules:

BO rows only when DIST TYPE is "CONSTANT"

DEGREE_FILL rows only when DIST TYPE is "CONSTANT"

SHOIL rows only when DIST TYPE is "STRETCHED_BETA"

 

I've got as far as using this expression in Filter rows:

([DIST] IN ("DEGREE_FILL", "BO")) And ([DIST TYPE]="CONSTANT")

but when I try and add the SHOIL STRETCHED_BETA filter, it falls over as I can't seem to get it to handle multiple cases. Any thoughts on how I can fit all of these filters in the one expression?

Cheers!

[Fredrik Rosell]

Hello,

Have you tested something like this?

(([DIST] IN ("DEGREE_FILL", "BO")) And (([DIST TYPE]="CONSTANT")))

OR 

(([DIST]="SHOIL") And ([DIST TYPE]="STRETCHED_BETA"))

[Charlotte Price]

I think I tried similar but was getting syntax errors probably due to brackets but this has worked perfectly. Thanks Fredrik!

[Fredrik Rosell]

Great - thank you for confirming.