This content has been marked as final. Show 2 replies
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.