2 Replies Latest reply on Dec 29, 2014 10:15 AM by Syed Khadir Ahmed

    Trend with the number of employees per month

    Ignacio Gonzalez-Blanch

      Hi there,

       

      I have a table with the the name of each employee, his start date and finish date. In the case that the employee is still active the finish date is empty.

       

      How can I build a monthly trend with the number of employees active on the last day of each month? for example: on the 31.3.12 I would need to account for all the employees who started before the 31.3.12 but their finish date is empty or later than the 31.3.12?

       

      The trend should be for all the months on a given period.

       

      Thanks!

      Ignacio.