Hi all,
I am trying to make a comparison between actual spend hours and planned spend hours on a project. But I cannot combine the data because there are no unique value's. I will explain a little bit more:
The actual hours are summarized by network, department, date, employeenumber, number of hours written on specific date by person
The planned hours are summarized by network, department, month, number of hours planned for department
I want to make a table in which the project, department, month are described with the actual number of hours and the planned number of hours. The specific date and employeenumber is not of importance anymore.
In the image you can see what is looks like, but in the real case there are of course thousands of rows. Anyone has an idea to easily do this?
Kind regards, Lars
Capture.PNG
Bookmarks