Hi @ArunSanthosh ,
I was able to achieve the functionality using Pivot table and parameters to change the inputs. and used the below calculations to get the Active headcount


Now I need to Add this active headcount +hires+terms to get expected ending headcount. But while doing that i am getting aggregation error
That is the only issue i am facing. Other than that Was able to get the similar functionality using this method.