How to filter out or exclude records of a OAC - DV Report based on a Condition/expression filter

Question

Hi Team,

Consider I am having a report with 5 dimension columns (A,B,C,D,E)and 5 measure columns (M1,M2,M3,M4,M5). I wanted to filter out or exlcude report records on basis of a condition - (if M1 = M2 then exclude those records from report).

How can we achieve this using a my calculation or using expression filter or by any other idea and how ?

Thanks,

Sohan

Gianni Ceresa · Accepted Answer

Hi,

Filters work by evaluating a condition to a TRUE or FALSE value for each row. And only when TRUE the row will be kept.

Because you have conditions that say when a row has to be excluded, you just need to take the opposite of those conditions.

Therefore, if you want to exclude rows where M1 = M2, you can add a filter being the opposite of M1 = M2, like M1 <> M2 for example.