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
