I have a request to provide my company an estimate of the number of work hours / days expected by the business to be involved a project so that they can perform their hiring forecasts for the year. I've created a project plan and assigned individual resources from different departments as well as grouped them in resource groups by department names.

I can derive the value of the number of hours / days per resource group for the entire project by using the Resource Overview report and grouping by resource group. I would also like to know this value per resource group till the end of the year (as budget for hiring is requested yearly).

However, when I try to apply the "Date Range" or "Should start by" filter with my expected end of year end date to this report, it does not return the correct result. I guess this is because resource work is determined not by task start but by assignment start.

When I try to use the task view to perform this, I get the correct I end up with a complicated report that does not categorize work by resource group but instead by tasks. For example, one task will have a total of 100 hours and 5 resource groups who could be contributing 20 hours each. The resource groups will also be duplicated if they are in different combinations for different tasks.

How can I achieve the report I want which should show in the first column "Resource Groups", second column "Remaining Work" and with the data on column 2 filtered for activity between the project start and the end of the year for example?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.