Filter out a value from a column only when combined with another value from another column

Gabriel_P

Hi everyone,

I have a table with two columns like the one below:

Company Code          Vendor No.

AAA                             1111

AAA                             2222

AAA                             3333

BBB                             1111

BBB                             2222

BBB                             3333

I need to create a custom filter whereby I exclude the Vendor value "1111" only when it appears in combination with the Company "AAAA" but I need to keep it for all other companies.

Can you please suggest how can it be done?

Thanks,

Gabriel

Kenda

Hey @Gabriel_P!

If your Vendor No. is a numeric field, you can use this custom filter in a normal Filter tool:

[Vendor No.]=1111 && [Company Code]="AAAA"

If it is a string field, just put quotes around the 1111 like this:

[Vendor No.]="1111" && [Company Code]="AAAA"

Then you will want to keep the F output from the tool.

Hope this helps!