Group Settings

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

Group Name

Enter a name for the group and select either Drill-down Group or Cyclic Group.

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 to include in the group.
Show Fields from Table Select a table.
Add Moves the selected fields from the column of Available Fields to the column of Used Fields.
Add All Moves all fields from the column of Available Fields to the column of Used Fields.
Remove Moves the selected fields listed in the column of Used Fields to the column of Available Fields.
Promote Moves the selected field one step further up in the list of Used 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 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 will be used as dimension name in the chart. The label may be defined as a calculated expression for dynamic update.
Sort Orders... Clicking on this button opens the Group Sort Order dialog in which a separate sort order can be set for each field in the group.