closing headcount

[Anonymous]

Hi All,

  I loaded active employee data from 10/01/1976 to 11/21/2016. I need closing headcount for last and current year by Month wise.

Start Date	End date	Closing Head count (2015)
10/01/1976	01-31-2015
10/01/1976	02-28-2015
10/01/1976	03-31-2015
10/01/1976	04-30-2015
10/01/1976	05-31-2015
10/01/1976	06-30-2015
10/01/1976	07-31-2015
10/01/1976	08-31-2015
10/01/1976	09-30-2015
10/01/1976	10-31-2015
10/01/1976	11-30-2015
10/01/1976	12-31-2015

Thanks,

Krishna

[marcus_sommer]

You could match your start- and end-date per IntervalMatch with a master-calendar and then just using year as dimension and a simple expression like count(employee).

- Marcus

[Anonymous]

Hi Krishna,

Kindly refer Number of employees month by month

[rido1421]

Hi Krishna

Maybe something like this will work for you ?