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 · Accepted solution]

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!

[Gabriel_P]

Thanks @BarnesK!

That was smooth.

[areeba]

Hi ,

Continuing with this requirement, if i have to make more than 2 combinations . for eg: company code : BBB with Vendor no. 2222 and Company code : BBB with Vendor no: 1111 then how should i do this ?

I tried  with custom filter :

[Company code]="BBB" && [Vendor no:]= 2222

And

[Company code]="BBB" && [Vendor no:]= 1111

and continues..........

then I took result from F output the tool.

but its not working for me . Can you suggest what i am missing here ?

Regards

Areeba