Forum Discussion
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.
Thanks for this reply. I have added the costs field in. How do I access the group by window to do the grouping you suggest?
- 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? - 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.
