1 Reply Latest reply on Jan 7, 2014 9:09 AM by Manas Ranjan Kar

    Comparing periods based on a dynamic value - Retail

    Manas Ranjan Kar

      This is a tricky one, (atleast for me !!)

       

      I have two columns, one is the Customer Code, other is the sales date. Now I need is to compare (MoM) the number of

       

      1. New Customers and

      2. Repeat Customers

       

      I can identify the new customers by looking at the last Customer Code generated in the last day of the previous month.

       

      Say on November 30, my last Customer Code generated is 1000, then for December, my repeat customers would be count of customer codes less than 1000 and new customers >1000. And this reference number changes every month of course.

       

      I have attached a sample workbook. Please help me out here, I am not able to wrap my head around the right approach for this.

       

      Thanks in advance !