Formula for Month Count from Start Month of CSAT

[PaweeArce]

Hello,

I was asked to create a table for the CSAT performance of each Class 1 given the following details:

CLASS	Start Month	Loan Purpose	Year
Class 1	Jan	Refinance	2023
Class 1	Jan	Refinance	2023
Class 2	Apr	Refinance	2023
Class 2	Apr	Refinance	2023
Class 3	Oct	Refinance	2023
Class 3	Oct	Refinance	2023
Class 3	Oct	Refinance	2023
Class 3	Oct	Refinance	2023
Class 4	Jan	Refinance	2024
Class 4	Jan	Refinance	2024
Class 4	Jan	Refinance	2024
Class 1	Dec	Purchase	2023
Class 1	Dec	Purchase	2023

Output to look like this:

CLASS	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	BAU
Class 1	95%	95%	95%	95%	95%	95%	95%
Class 2	85%	85%	85%	85%	85%	85%	85%
Class 3	70%	70%	70%	70%	70%	70%	70%

Appreciate if someone can provide me the formula on how to calculate the month count or month#.

thank you in advance.

Pawee

[caltang · Accepted solution]

I've built something simple for you, but not sure how you calculate BAU or even if the numbers make sense from the data because I'm using Count # / Count TOTAL # for % calculations.