2 Replies Latest reply: Apr 10, 2012 8:15 AM by THe_evaco RSS

    Product Cross Sell Pivot Overview?

      Hello all,

       

      this must be a very common question, but so far I did not find a solution in the forum.

       

      I have a raw data table showing which customer (1..6) bought which product (A.B.C)

       

      My goal is to achieve an overview, which customer of product A has also purchased product B.
      I want to have that in a (pivot) table. I found solutions in the forum where the information is provided based on a product or customer selection, but this is not what I need. I want to show the result based on a “clear” selection.

       

      Raw data:
      (Row 1 reads ‘Customer 1 bought products A, B, and C’
      Row 2 reads ‘Customer 2 bought only products A’)

       

      CID

      A

      B

      C

      1

      x

      x

      X

      2

      x

       

       

      3

      x

      x

       

      4

       

      x

      X

      5

       

       

      X

      6

       

      x

       

       

       

       

      Desired Result:
      (Row 1 reads ‘2 customers bought products A AND B, 1 customer bought products A AND C’)

       

       

      A

      B

      C

      A

      -

      2

      1

      B

      2

      -

      2

      C

      1

      2

      -

       

       

       

      I worked with the aggr function, e.g. to find out how many customers have bought more than 1 product, but I fail to get the pivot done. I just don’t understand how to combine the calculated dimensions with the set analysis … which must be the way doing it … or not?

      Thank for any hints,

      Thilo