Presentation setting

Describes how to set the layout of a report.

Procedure

To set the layout, click Layout.
To set the high and low limits for data, click Limit. From the Limit column drop-down list, select the name of the column whose values you want to limit. From the to values drop-down list, select the function by which to limit values. Then type the value to set the limit. You can also suppress the display of missing values in a report by clicking Suppress Missing. If you apply a limit to any column, the Suppress Missing option is automatically selected.
To order dimensions and members by a specific column, click the column heading.
To order dimensions and members alphabetically, select Order dimensions alphabetically from the Order drop-down list.
To order dimensions and members hierarchically, select Order dimensions hierarchically from the Order drop-down list.
To control whether all higher levels of a dimension are displayed when drilling down, click Show Parents.
To display a Grand Total row, click Column totals. To include a % Total row at the bottom of the report, click Show % next to Column totals.
To display a Total column across the report, select Row totals. To include a % Total row across the report, click Show % next to Row totals.