How to display Active employees count month wise

Summary

How to display Active employees count month wise

Content

Is there any way  on calculating employee count by month in OAC.

The starting point is an Employees table with the start and end date of each employee. For employees currently at the company, the end date is empty or future Date.

An example is below.

Employee table Expected Output..   HEADCOUNT   KPI’s Previous Year 2019       1st Q 2nd Q 3rd Q 4th Q YTD     Average Headcount Average Headcount   JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL   Executive 1 1 1 1 1 1   1 1 1 1 1 2 1 1 1 1 1 1 1   Management 23 22 20 20 20 20   23 23 22 21 21 20 20 21 20 20 20 20 20   Staff 473 453 481 475 469 469   459 455 447 482 482 480 479 476 472 469 469 469 469   Labours 109 102 104 103 99 102   103 103 102 107 104 103 105 103 101 100 99 100 102     1         0   0 0 0 0 0 0 0 0 0 0 0 0 0   Total 607 578 606 599 589 592   586 582 572 611 608 605 605 601 594 590 589 590 592