Number of employee per month

[fezekandlela]

Hi, I want to use the Employee Summary table to calculate the number of employees per month and year. The aim is to track the increments and decrements in the total number of employees.

EmployeeSummary:
LOAD
Paypoint,
EmpNo,
EmpFirstname,
EmpSurname,
EmpId,
"group Start Date",
"Recruitment Date",
"Job Name",
"OS Name",
"Payment Type",
Gender,
Race,
"Employee Type",
Status

[BrunPierre]

This expression should indicate the number of active employees per month. It only considers employees who have an "active" status and whose termination date is on or before the last day of the month.

=Count(DISTINCT {<status = {'active'}, resignDate = {"<=$(=MonthEnd(Max(resignDate)))"}>} empNo)