1 Reply Latest reply on Mar 20, 2016 2:24 PM by Bill Lyons

    % of Repeat Customers from Previous Month

    Amos Mbugua

      Hi,

      I would like to measure the % of repeat customers from the previous month in the current month.

       

      The formula am using is ;

       

      % Repeat Customers In Dec = ( # of customers ordered in Nov & Dec ) / ( Total # of customers Ordered in Nov )

       

      I have attached a copy of the workbook.,

       

      Regards,

       

      Amos.