Hello,
I am trying to make a pivot table report based on our employee database via an ODBC query and need the help of some the real experts :-)
In my data I have the following fields:
Company, Department, Name, Date in service, Date out of service
In my pivot I have a start and end date (example 1-1-2015 till 31-12-2015)
Any employee not actively in service will be filtered out in the query (date out of service >= [Start date] or Null)
Now my big challenge:
I would like to build a pivot table which lists all employees by department and show for each month of the year if they were in service
I have attached an Excel showing the data that I get from my database and the pivot which I would like to build
Can someone help me and tell me if it will be possible to create such a pivot if so how?
The problem is that I only have 2 dates per employee; in service and out of service
Bookmarks