6 Replies Latest reply: Aug 6, 2015 9:57 AM by Srikanth P RSS

    Exclude transactions with set analysis

    Joey Stekkinger

      Dear community,

      I have a lot of transactions, in which a customer can buy products of the category A, category B, or offcourse both.

      Now I am interested in how many customers buy ONLY A, ONLY B, and I would like to know how many customers buy BOTH A and B.

       

      Although I assume its a very easy set analysis expression, I cant get it right.

      COUNT(DISTINCT Transaction) would give me al transactions,

       

      COUNT({<Category={"A"}>}DINSTINCT Transactions) would give me all transactions with customers buying product A or A and B combined.

       

      But I want only those that buy A and NOT B. And those that combine A and B.

       

      Any suggestions would be highly appreciated!