Group a report by a multi-select custom field

Create a report or edit an existing one where you want to add a grouping for a multi-select custom field.
For information about creating reports, see the article Create a custom report.

Click Report Actions, then Edit.

Select the Groupings tab.

Click Switch to Text Mode.

Select the text in the Group by box and replace it with the following code:

group.0.displayname=Multi-select Custom Field Name
group.0.valueexpression={DE:Multi-select Custom Field Name}
group.0.valueformat=HTML
group.0.textmode=true

Replace “Multi-select Custom Field Name” with the actual name of your multi-select custom field, as it appears in your Workfront instance.

Click Save and Close.

The objects in the report are grouped by the values of the multi-select custom field.

The name of the groupings of the report are the names of the multi-select custom field followed by the values selected in the field.