You'll need two custom groups:
For the Projects and Resource hours per project:
In the master file, apply the Task Usage view and create a group that groups by Project and then by Resource Name. Click the Check box for "group assignments not tasks" and select Assignments in the field type for the Resource Names row. Zoom out of the Task Usage view to show months.
For the Resources and Projects hours:
In the master file, apply the Resource Usage view and create a group that groups by Name and then by Project. Again, click the Check box for "group assignments not tasks" and select Assignments in the field type for the Project row. Zoom out of the Resource Usage view to show months.
|