AND Logic Slicer

[ortiz99]

Hello!

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

Then, I have a smart silcer by okviz with an OR logic, like the one below:

I want that, when I search for example for "Tool1" and "Tool 3", then, in another table like the next one, appear the codes that contain any type of experience (1, 2 or 3) in the tools searched (in this case, 123 and 543)

The slicer has to have AND logic.

Thank you very much!

[ortiz99]

I mean,

Imagine you search in the slicer for Tool 1 and Tool 3. If you look in the table, for code 123, Tool 1 has 1 of exp, and Tool 3, has 1 of exp. Also, for 543, Tool 1 has exp 3 and Tool 3 has exp 3. But for code 894, Tool 1 has exp 2 and tool 3 has exp None.

So, I want that, when I search for Tool 1 and Tool 3, in the last table whose header is "Code", appear codes 123 and 543, because they are the ones that, for the tools searched, have almost a number of experience (exp). And 894 shouldn't appear because in Tool 3, it has experience "None"

Ask me if necessary for any doubt.

Thank you very much

[Anonymous]

Hi @ortiz99 ,

I'm a little confused about your needs, Could you please explain them further? 

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu