Crosstab Wizard

This wizard is displayed when you do one of the following:

• Select a crosstab, then click Menu > Edit > Wizard.
• Select a crosstab, then click the Crosstab Wizard button on the Context toolbar.
• Right-click the icon of a crosstab and select Crosstab Wizard from the shortcut menu.

It helps you to change data of the crosstab. See the wizard.

Crosstab Title

Specifies a title for the crosstab.

Sets the font, font style, size, alignment, font color and background color properties for the crosstab title.

Data Source

Displays the business view that has been used in the crosstab.

Filter

Opens the Query Filter dialog to specify the filter which you want to apply to the selected business view.

Resources

Displays the view elements in the selected business view.

Edits the selected dynamic resource.

Adds the selected group object to be displayed on the columns of the crosstab.

Adds the selected group object to be displayed on the rows of the crosstab.

Adds the selected aggregation object or detail object to be the summary field of the crosstab.

Columns/Rows

• Field
  Lists the group objects that will be displayed in the columns/rows of the crosstab.
• Label
  Specifies the display names of the group objects. By default these are blank and no names will be created for the group objects to label the columns/rows. You can click in the cells to edit them if required.
• Sort
  Specifies the sort order of the group objects.

Summaries

• Field
  Lists the aggregation/detail objects that you select to create summaries.
• Label
  Specifies the display names of the aggregation/detail objects. By default these are blank and no names will be created for the objects to label the summaries. You can click in the cells to edit them if required.
• Aggregation
  Specifies the functions used to summarize data of the detail objects.

Moves the selected view element one level up.

Moves the selected view element one level down.

Removes the selected resource.

OK

Applies the changes and closes the wizard.

Cancel

Does not retain changes and closes the wizard.

Help

Displays this help document.