View a spreadsheet of resource allocation across all projects
- In the Activities window, choose View, Show on Bottom, Resource Usage Spreadsheet.
You can also click the Layout Options bar, then choose Show on Bottom, Resource Usage Spreadsheet.
- In the right pane of the bottom layout window, click the Display Options bar and choose Show All Projects, if it is not already selected. A check next to Show All Projects indicates that it is selected.
To view total allocation by resource, click the Display Options bar in the left pane of the bottom layout window, then choose Select View, By Resource.
To view total allocation by role, click the Display Options bar in the left pane of the bottom layout window, then choose Select View, By Role.
Note
- Dashes display in the cells of summary rows if your selection contains a mixture of labor/ nonlabor and material resources.