In Your showcase of Churn Analysis https://www.youtube.com/watch?v=h9kRwgamLcw&t=29s
, you illustrated how to calculate the new, retained and lost customers, but the problem all this measure cannot be taken as an overall (retention) rate like in the case of cohort analysis :
I tried to put it as a pivot table to calculate the retention rate as a cohort for each month by putting the Months Numbers as a column and the (Year & Month) as rows and customer count as value , but it does not give me accurate numbers on each month as shown in the pictures below:
What sort of changes shall we do in your showcase to calculate cohort analysis as it
shown in the mentioned links above?