# Group Settings

The Group Settings dialog is opened when clicking the New... or Edit... buttons in the Document Properties: Groups dialog.

Group settings

| Setting | Description |
| --- | --- |
| Group Name | Enter a name for the group and select either Drill-down<br>Group or Cyclic Group.<br><br>Information note Do not use a name identical to the name of any field that is used in the group. |
| Available Fields | Available fields are listed in this column. Select the fields<br>to include in the group. |
| Show Fields from Table | Select a table. |
| Add | Moves the selected fields from the column of Available<br>Fields to the column of Used Fields. |
| Add All | Moves all fields from the column of Available<br>Fields to the column of Used Fields. |
| Remove | Moves the selected fields listed in the column of Used<br>Fields to the column of Available<br>Fields. |
| Promote | Moves the selected field one step further up in the list of Used<br>Fields. |
| Demote | Moves the selected field one step further down in the list of Used Fields. |
| Used Fields | Fields included in the current group are listed in this column. Initially<br>the column is empty. |
| Add Expression | Opens the Edit Expression dialog for easy editing of long formulas. |
| Edit... | Opens the Edit Expression dialog for editing the selected formula in the Used Fields area. |
| Label | An alternative name for the displayed field can be entered here. It<br>will be used as dimension name in the chart. The label may be defined<br>as a calculated expression for dynamic update. |
| Sort Orders... | Clicking on this button opens the Group Sort Order dialog in which<br>a separate sort order can be set for each field in the group. |