Forums » Help »
Resource Loading Report
Added by John Steck 4 months ago
How do I get a summary report that tells me what specific projects every person in the database is working on... I am trying to get a dynamically generated / on-demand resource loading matrix/table. Ideally I want to be able to see who is working on what, how many projects each person is working on, and how many people are working on a given project:
|
Project A |
Project B |
Project C |
Total |
| Person A |
|
X |
X |
2 |
| Person B |
X |
|
|
1 |
| Person C |
X |
X |
X |
3 |
| Person D |
|
|
X |
3 |
| Total |
2 |
2 |
3 |
|
Is there a way to pull this info and format it this way? It seems like this should be a built in report...
Sorry, the person D total is wrong. Exactly the reason I want this table automagically generated... 8^)
| |
Project A |
Project B |
Project C |
Total |
| Person A |
|
X |
X |
2 |
| Person B |
X |
|
|
1 |
| Person C |
X |
X |
X |
3 |
| Person D |
|
|
X |
1 |
| Total |
2 |
2 |
3 |
|