Creating a table report

Tables give you great control over how to present data, including placing fields, grouping them, and sorting them. A table is composed of row and columns, and each contains several cells. With such a structure a table is a good way to show any two-dimensional dataset.

To create a table report, follow the steps below:

1. Take steps 1 and 2 in Creating a report tab.
2. In the Choose Report Layout box, select the desired table type, then click OK to display the Table Wizard.
   • Table (Group Above)
     Creates a table with group information above the detail panel.
   • Table (Group Left)
     Creates a table with group information left to the detail panel.
   • Table (Group Left Above)
     Creates a table with group information left above the detail panel.
   • Summary Table
     Creates a table with only group and summary information.
3. In the Data screen, select the business/report cube in the current catalog, on which the table will be built.
4. In the Display screen, add the required fields from the Resources box to be displayed in the table. Modify the display name of any added field if necessary.
5. In the Group screen, add the dimension objects as the grouping criteria, then specify the sorting direction of each group in the Sort column.
6. To add summaries, go to the Summary screen. Select the group to which the summary will be applied, then add a measure object as the summary field. For the Group Left table, you can use the Row and Column columns to control the position of the summary field in the table.
7. In the Query Filter screen, specify the filter you want to apply to the business/report cube.
8. In the Style screen, apply a style to the table.
9. Click Finish to create the report.

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