This tab can appear as part of several dialog boxes:
Note The Options tab does not appear in the Chart Sort Order dialog box.
For example, you could group on the Customer ID, but display the Customer Name as the group name. To do this, select the Choose From Existing Field option and choose the appropriate field from the list.
Alternatively, you could group on the Customer ID, but use the following formula to display both the Customer ID and the Customer Name in the group name:
ToText ({Customer.CustomerID}) + " : " + {Customer.CustomerName}
To do this, select Use a Formula as Group Name and click the Formula button to enter your formula in the Formula Workshop.
Note
The Customize Group Name Field option is not available for groups sorted "in specified order."
You cannot include a field that is evaluated at runtime, such as a running total field, summary field or another group name field, in a group name formula.
Note This option does not appear for the Cross-Tab Group Options dialog box.
Note This option does not appear for the Cross-Tab Group Options dialog box.