6 Replies Latest reply: Feb 16, 2017 2:34 PM by Richard Judkins RSS

    Wildmatch with two criteria

    Richard Judkins

      Hey all

       

      So I have the following: (if (WildMatch(PROD_GROUP, '*Mud*','*Salt*'),'Mud and Salt',null)), with the measure being count(customers).

       

       

      The issue I have is that it is returning the count of the total number of customers who have Mud, and the total number who have Salt.

       

      What I want is the number of customers who have both products.

       

      Any help please?

       

      Thanks