Q-1
How can we create calculated column calculate the churn rate for each row of the cohort (Start from 1 to 12)?

Here is the equation I got it from one of the sites:
Churn rate=User Lost this year/(Users at Start of Year+Users Added This year)

Here’s an Annual Churn Rate Example:

Users at start of year (Cohort) : 50,501
New users added during year (Cohort): 16,765
Users lost at the end of year: 27,890
Annual churn rate: 27,890/67,266 = 41.5%

The above picture display cohort information based on the number of unique customers on each period of a cohort, I need to display the cohort based on customer sales not on the number of the customers what sort of changes I should do?

Kindly show me this calculation in your latest Cohort analysis showcase introduced in 2018 (I think in last November 2018).

Everything is there in the example file from this session below.

I recommend going through this in detail and really understanding the concepts explained during this one.

Everything is there around the techniques required to get the answer you require for this. It just requires inputting what you require into the correct formula.

Thank you Sam , Is this equation related to the ( Annual Churn Rate) equation I mentioned it in Q.1?
For Q.1 I mean the (No Of Customers) , For Q.2 I mean the Sales

I think Sam You didn’t understand my Question clearly the (Retention %) , according to your solution it always display 100% which is not true , Please return back and read the question again , the resources is available on your website here is a link example if you want to know how to calculate the churn rate https://clevertap.com/blog/churn-rate/ .