...
Select the Database (Holding).
Select the appropriate Holding table and the column on which the field attribute is to be based.
For fields used in single period reports, set the Process field to End Date Holding or Entity.
For fields used in multi period reports, assign the appropriate process, either Begin Date Holding or Entity or End Date Holding or Entity.
Set the Field Indicator field to user defined.
Create any custom field attributes, such as detail calculation fields, based on source-specific fields.
...
All holding field attributes must be source specific to create a report using source-specific holding field attributes. Even though sources have been selected for the field attributes, you must also specify a mandatory holding source for the report, which is a dummy source.
Workspace Positions Single Period Using Source Specific Holding Fields
Report Results for Positions Single Period Report Using Source-Specific Holding Fields
Source-Specific and Relation Fields
...
In a report rule, add a field that is configured with a translation code.
...
Change the sort from default to custom.
Workspace - Sort For Code Value
Select the values in the order you want. You can reorder them at any time using drag and drop.
Click Done.
...
Custom sorting is now set. To make changes to the order, double-click on the Custom cell.
...
Use the Sort column in the grouping rule to configure custom sorting for a translation code enabled field placed in a grouping rule.