Forum Discussion

Copper Contributor

Oct 21, 2019

Solved

Can I see which Project all of my resources currently are on?

Currently I See all my resources in Resourcecenter, and I Group them by resource department and then by title. Can I see which project they are currently on? So that I can have a total overview ...

Paul_Mather
Oct 22, 2019
Hello Marinpetersen,

You can either build a Power BI / Excel report to see this information or from the Resource Center in PWA, select the resources then click the Resource Assignments button - that will then load a grid that shows you what projects the selected resources are working on.

Paul

Paul_Mather

MVP

Oct 22, 2019

Hello Marinpetersen,

You can either build a Power BI / Excel report to see this information or from the Resource Center in PWA, select the resources then click the Resource Assignments button - that will then load a grid that shows you what projects the selected resources are working on.

Paul

Marinpetersen

Copper Contributor

Oct 24, 2019

Hello Paul_Mather

Thank you for your response, I will look into how I can set a report in excel.

I am familiar with the pwa option resource assignments, but I don't want to have to choose which resources to see, and as I understand I have to choose which resources I wanna see and only up to 100, with the resource assignments option, is that correct?

I can try to give an example, I want a simple overview saying how many resources I have, how many I have in which department, and how many are on projects and how many are "loose":

All resources : 250

- Department 1: 100

- - Project 1: 50

- - Project 2: 20

- - "Loose": 30

- Department 2: 70

- - Project 1: 40

- - Project 2: 30

- - "Loose": 0

- Department 3: 80

- - Project 1: 40

- - Project 2: 30