we mainatained joining date, Resigned date and last working day properties in employee dimension.
Based on those properties we need to calculate previous 6 months Organization Active employees and resigned employees count.
We create one module called headcount planning module.In these scenario current period is july-2018.
In these module we need to show the Position wise,Location wise actual headcount data. By using Joing date, resigned date and last working day properties we need to calculate data.
For eg: in Jan 18 100 employee joined in the organization and 50 employees are left. Then in jan month actual headcount is "Currently working employees+Jan recruited employees-Jan left employees.
Same way we need to calculate previous 6 months actual Headcount data need to be display.
Hope you undestand.
can you please suggest me.