1 Reply Latest reply on Jan 29, 2019 2:28 AM by Mahfooj Khan

    How to calculate MOM Customer Retention over a Period of Time

    pravallika reddy

      Hi All,

       

      I have a requirement to calculate the Month over Month Customer Retention (Eg: All players deposited in Month A (Eg. Jan): 1000, out of them how many of them deposited in month B (Feb), and keeping January as base month we need to complete this table – for any selected date range) by using LOD function but I get it for only individual years but I did not get this for any selected date range like for 2 years or more than 1+ year .  I am sharing the sample workbook along with reference screenshots. I want the Retention analysis as shown in the reference screenshots.

      Kindly let me is there any way to calculate MOM Customer Retention.

       

       

      Thanks and Regards,

      Pravallika.