Quick Filter which enables a select with an "AND" Condition (as opposed to the traditional 'OR')

Nick_Bertz

Hello,

 

I am looking for some functionality, which i envison being a type or class of 'Quick Filter'.  This quick filter would enable an AND as opposed to the 'OR' which is the standard functionality (within that particular quick filters own values).

 

Here is an example of my requirement which illustrates what i'm asking for:

 

I have some sales document data

[Sales Doc]  [Line No]   [Product]

1000             10             X

1000             20             Y

1000             30             Z

 

2000             10             A

2000             20             B

2000             30             Z

 

3000             10             X

3000             20             A

3000             30             Z

etc....

 

My requirement is to have a user be able to select products (A user could select any combination of products), so in our example the pool of products is [A,B,X,Y,Z], however there are hundreds of products in reality (which means innumerable combinations).

 

When the User selects Product X AND Z, i expect the results to be Sales Lines that include X AND Z, so in this case

[Sales Doc]  [Line No]   [Product]

1000             10             X

1000             30             Z

3000             10             X

3000             30             Z

 

Notice that Sales Doc 2000 is not listed as it doesn't contain BOTH products.

 

I haven't figured out how to solve this problem with standard Card functionality, hence the ask.

 

Thank you!