Hello everyone,

I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.

I created a Quick Filter to show only the materials that belong to P18, and it works correctly:

FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')

I did the same for materials that belong to P20, which also works correctly:

FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')

However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:

FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')
AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')

Do you have any idea how to fix this?

Thanks!