Report to get active staff as end of actual month vs their situation in the previous month
Summary:
I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs end of previous
Content (please ensure you mask any confidential information):
in the context of headcount management the purpose is to see all the mouvements and changes such as change of business unit, region, country, contract below an example :
Something similar: comparison between a headcount report of 31/05 vs 30/04
Is anyone has a first SQL drft Code that managed similar topics ?
Thank you
Version (include the version you are using, if applicable):