4 Replies Latest reply: Mar 27, 2014 8:07 AM by David Young RSS

    Ranking question

    David Young

      I have the following information:

       

      Client Name        Product              Purchase Date

      1                              A                         1/1/2014

      1                              B                         1/1/2014

      1                              C                         3/1/2014

      2                              A                         1/5/2014

      2                               B                         2/1/2014

      2                              C                         3/1/2014

      3                              B                         1/7/2014

      3                              A                         2/7/2014

      3                              C                         5/7/2014

       

      The first results I would like is:

       

      First Purchase    Count of Clients

      A                              2

      B                              2

      C                              0

       

      The second one which is not easy is if I select Product A what is the next product that is purchased?

       

      Thoughts are welcome.

      David