Group Microsoft Project Usage Views by Task and Resource Fields
Question details
Group assignment information by an accounting number and a custom cost type drawn from task and resource data.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- The user wants a Usage view that groups assignments using both task and resource attributes.
- Observed behavior
- Task Usage and Resource Usage expose different fields, so both attributes are not readily available for grouping in the same view.
Identify whether the accounting number and cost type are stored as task or resource custom fields, and check which one can vary by assignment. Open the intended Usage view and inspect its available grouping fields before choosing where to place the data.
Make both attributes available in the chosen Usage view
Use a suitable extra field or assignment-level data translation when the desired grouping fields are not both exposed in the view.
Task, resource, and assignment data have different scopes. A task-level field alone cannot represent different values for multiple resources assigned to the same task; the equivalent limitation applies to a resource-level field when its assignments have different values.
Field availability and editability depend on the view and field. An assignment-level translation may require automation, and changes to source fields may require the translated values to be refreshed.
Open Project > Custom Fields and select Task or Resource to identify the fields that hold the accounting number and cost type. Note which values must be distinct for each assignment.
Open View > Task Usage or View > Resource Usage. Then open View > Group By > More Groups and inspect the fields available when creating a group.
Choose an unused field that is available and appropriate for the selected view. Copy or calculate the missing attribute into it only if its scope preserves the needed values. If values vary by assignment, investigate a writable assignment-level field and an automation method supported by your Project version.
In View > Group By > More Groups, create a group using the fields that contain the accounting number and cost type. Apply it to the Usage view and compare several assignments against their source task and resource values.

Build a grouped report from exported Project data
Use a spreadsheet report when the required fields cannot be grouped together reliably in a Usage view.
Analyze exported Project data with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open an exported Excel workbook in WPS Spreadsheet to sort and analyze assignment data, making it easy to move an existing report workflow without changing the Project file itself.

Frequently Asked Questions
Why can't I group by both custom fields in a Usage view?
Task Usage and Resource Usage expose different task, resource, and assignment information. Open View > Group By > More Groups to check which fields are available in the selected view.
Can I put a resource value in a task custom field?
You can use a task field only if one value per task accurately represents the data. If a task has multiple assigned resources with different values, a single task field cannot distinguish those assignments.
Will translated fields update automatically when the source changes?
Not necessarily. If you copy values or use a script to populate another field, repeat the copy or run the automation again when the source data changes, unless you have set up a supported automatic refresh.
Can WPS Spreadsheet change grouping inside Microsoft Project?
No. WPS Spreadsheet can open an exported Excel workbook and help you analyze its data, but it does not change the grouping in a Microsoft Project Usage view.




