Creating a crosstab report

A crosstab summarizes data and presents the summaries in a compact row and column format.

To create a crosstab report, follow the steps below:

1. Take steps 1 and 2 in Creating a report tab.
2. Select Crosstab as the layout and click OK to display the Crosstab Wizard.
3. In the Data screen, select the business/report cube in the current catalog, on which the crosstab will be built.
4. In the Display screen, select a dimension object and click or to add it to the Columns or Rows box as a group field. Select a measure object and click to add it to the Summaries box as an aggregate field. Repeat this to add more group/aggregate fields.
5. In the Display Name column, edit the display names of the added group fields or aggregate fields if required. These will label the rows, columns and summaries when the report is displayed. By default these are blank and no labels will be created.
6. In the Sort column, specify the sorting manner for the group fields.
7. If you want to remove any group/aggregate field, select it and click . To adjust the order of the group/aggregate fields, select a group/aggregate field and click or .
8. In the Query Filter screen, specify the filter you want to apply to the business/report cube.
9. In the Style screen, apply a style to the crosstab.
10. Click Finish to create the report.

See also Crosstab Wizard for details about options in the wizard.