Forum Discussion
Solved
MS Project Resource Pool Usage
I wonder if I can ask a question, guys?
I am working with a company that is using a Resource Pool and have allocated it across several projects.
However, when we look at the costs of resources on each project, we get the overall costs for resources for all projects. (Using MS Project 2021 Pro)
I assume there must be a way to create a report on each project instance of what the resources are costing for just that project. Any help would be appreciated. I tried a few options, but it didn't seem to change from costs for all projects.
Hi Tamsons .
Try inserting the Cost column into the Resource usage view table, and group by the Project field and Then by Name, selecting in the Group form: "Group assignments, not resources" selected, "Project" in Field Name, "Assignment" in Field Type, "Name" in Field Name, and "Resource" in Field Type.
I hope you find it useful.
Hi Tamsons .
Try inserting the Cost column into the Resource usage view table, and group by the Project field and Then by Name, selecting in the Group form: "Group assignments, not resources" selected, "Project" in Field Name, "Assignment" in Field Type, "Name" in Field Name, and "Resource" in Field Type.
I hope you find it useful.
Ignacio_Martin thanks for your help, I have the same situation and it worked for me to get project cost and hours (Work) for shared resources. Now I realize that for %-Allocation the same logic doesn't work as expected. I posted the following question: Show correct %-Allocation in Resource Usage for a specific project when using Resource Pool. If you have any idea on how to solve this, please help answer the question. Thanks so much.
- davidleal,
See the answer I posted to your original question.
John
- Ah, I may have cracked this. It doesn't total each resource for each project. So any feedback on that would be helpful. Thanks in advance.
Hi Tamsons.
Below the reply box, a text that says "Open full text editor" is displayed, from where you can insert images. If it doesn't appear, you may need to register.
I attach an image of the resources (R1, R2, R3) grouped by projects (Project A, Project B, Project C), with their corresponding and totaled allocations and costs.
Regards.
- I have grouped by the project field and have tried to do a custom group in the resource name field and am getting a blank window as below.
Sorry this won't let me post a copied image?
