Turnover Report

Summary

Looking for help creating a turnover report

Content

Hi,

We have set-up turnover reports but when I checked the data the report is not pulling the correct information.  I will include the SQL below.  I am looking to identify headcount by Business Unit over a 6 year period by month.  It looks like the report is only showing people who are currently active in the business unit rather than if they were active at the time.  Has anybody been able to produce a report like this and would be willing to share?

Thanks

Sam

SET VARIABLE PREFERRED_CURRENCY='Local Currency',PREFERRED_CURRENCY='Local Currency';SELECT