3 Replies Latest reply on Mar 2, 2016 4:51 AM by Mark Fraser

    Retained customers from last year compared to the total number of customers the year before

    Rasmus Gars Holm

      Hi Community,
      I am struggling with a calculation regarding retained customers from last year compared to the total number of customers the year before.

      Basically I would like to find sum of customers who were shopping at my shop last year and this year / total number of customers at my shop this year.

      Thus;
      2011: 100 customers are shopping in 2011

       

      2012: how many of the 100 customers who were shopping in 2011 does also shop in 2012.

                in 2012 there are a total of 120 customers (new and from 2011).

       

      2013: How many of the 120 who were shopping in 2012 does also shop in 2013?


      Any ideas about how to solve this?