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?