I have a query with 2 fields on which I want to add a filter criteria
Invoice Unit - Exclude data with value M2N - criteria is <>"M2N" - works
BUT I dont want this filter to work for 3 Customer Codes - say A,B and C.
Meaning filter condition is filter out all records where Invoice Unit is M2N BUT not for customer codes where Invoice unit is M2N AND CustomerCodes are A,B or C
How does one achieve this?
Invoice Unit - Exclude data with value M2N - criteria is <>"M2N" - works
BUT I dont want this filter to work for 3 Customer Codes - say A,B and C.
Meaning filter condition is filter out all records where Invoice Unit is M2N BUT not for customer codes where Invoice unit is M2N AND CustomerCodes are A,B or C
How does one achieve this?