1 Reply Latest reply: Feb 21, 2013 1:44 PM by Gysbert Wassenaar RSS

    Brand And Shopping Cart Analysis

      Hello!

       

      I'm having a challange solving a problem for an end-user. What the user wants is more or less an analysis of what brands their customers purchase, if they purchase XX and also purchase brand YY.

      Trying to put it simple; Customer purchase brand A, B and C - selecting brand A would get possible selections on brand B and C. and so on.

       

      The result would be something like this;

       

      BRAND1      BRAND2

      A                 B

      A                 C

      B                 A

      B                 C

      C                 A

      C                 B

       

      If another customer buy items of brand C and D then the tables should be something like this

       

      BRAND1      BRAND2

      A                 B

      A                 C

      B                 A

      B                 C

      C                 A

      C                 B

      C                 D

      D                 C

       

      and so on.

       

      Have tried to search for something in these lines without any success unfortunately.

      Is there someone out here that has a clue on how to achieve this or has any input at all I would love to hear your ideas.

       

      Thanks in advance!

      //Niklas