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.