1) How can we find the last three quarter count of person I'd separated for every quarter.example if we want to find the count for Q1-2022 ,we need to add count of person I'd in quarters like Q1-2022+Q4-2021+Q3-2021+Q2-2021,similarly for every quarter we want to find the count of person I'd attrited.
2) Second requirement is we want to find the % for every quarter for this we need to divide the count obtained above for every quarter with the freezed headcount of that quarter month end only .
For example if we want to find the % for any quarter we need to divide the count obtained in 1 for every quarter with the freezed count of last month of every quarter .for Q1-2022 we need to didvide the count by freeze headcount of June 2021 similarly for Q4-2021 we need to divide the count of Q4-2021 with freezed headcount of mar 2020.
There are two table given for this requirement .
1)Separation table - it has two columns person I'd and transaction date.
2) Freezed table - it has two columns month year and person I'd .
