I would like to build a table much like the table build in the time based cohort analysis training that was done here.
The difference is instead of analyze customer churn, I would like to analyze sales adoption by period.
My definition of sales adoption is the following:
Monthly sales in period 1 / Max monthly sales for customer
Customer 1: Max Monthly sales = 100
Month 1 Sales = 15
Month 2 Sales = 30
Month 3 Sales = 60
Month 4 Sales = 100
In Month 1 Sales Adoption would be 15% and so on.
This will give me an idea of the adoption over time by customer.