Others

Group Microsoft Project Usage Views by Task and Resource Fields

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 870 views

Question details

Group assignment information by an accounting number and a custom cost type drawn from task and resource data.

Group Microsoft Project Usage Views by Task and Resource Fields
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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the source fields

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.

2
Check available grouping fields

Open View > Task Usage or View > Resource Usage. Then open View > Group By > More Groups and inspect the fields available when creating a group.

3
Translate the missing value

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.

4
Create and test the group

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.

Make both attributes available in the chosen Usage view
Check inherited values: A field visible on an assignment row may be inherited from a task or resource and may not be independently editable. Test the field before relying on it for assignment-specific grouping.
Free Microsoft Office alternative

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.

Sort or summarize exported assignment data by accounting number and cost type.Compatible with Microsoft Excel workbook formats, including XLSX.Familiar spreadsheet interface for an easier transition from Microsoft Office.Free and lightweight for everyday document and spreadsheet work.
microsoft office alternative - wps office

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.