7 Replies Latest reply: Mar 2, 2012 8:11 AM by Stefan Wühl RSS

    Set-Analysis comparing selections

      I want to count how many customers who has bought each product. And this is not a problem for me. But when I want to count how many customers who has bought a combination of products then I have a problem. Is ther any possible solution.

       

      If I would like to know how many customers who has a combination of product 02 and 04

       

      Is it possible to have a presentation like this.

      Product  Numbers of customer

      02 not 04   1

      02 and 04  2 

      04 not 02   1

       

       

      Load * inline
      [CustomerID, ProductID
      1,03
      1,02
      2,04
      3,05
      3,03
      4,03
      5,02
      5,04
      6,04
      6,06
      6,02 ];