3 Replies Latest reply: Feb 13, 2013 4:21 PM by Freddy Johnsen RSS

    How to calculate new customers and new products compared to last year

      Hi,

       

      I am a bit stuck trying to calculate new customers this year compared with last year. Hope somebody can help me.

      I am working on detailed transaction data.

       

      Data:

      Year

      Date

      SalesAmt

      ProductId

      CustomerId

       

      I am looking to answer the following questions:

      1. What customers have I sold to this year (2013) that I did not sell to last year.

      2. How many customers have I sold to this year that I did not sell to last year

      3. What is the amount I have sold this year to new customers

       

      Regards,

      Freddy