9 Replies Latest reply: Aug 12, 2015 10:34 PM by arjun rao RSS

    Current vs. previous year

      I have the following data.

         

      YearCustomerAmount
      2010ABC200000
      2011ABC240000
      2012ABC288000
      2013ABC345600
      2014ABC414720
      2015ABC497664
      2012BCD125000
      2013BCD250000

       

       

      I want the following:

      a. loyal customers. i.e. the list of customers who purchase regularly in all the years

      b. new customers -  when I select a year, I want the list of new customers added in that year and their amounts

      c. Lost customers - Customers who didn't business forever. for eg, BCD didn't do business for 2014 and 2015.