About presentation setting

Provides information about what you can do to set the layout of a report.

You can do the following to set the presentation of the report:

You can specify which dimensions will appear in the report, and the location of dimensions, measures, and time in the report.
The initial view displays time across the table and measures displayed down the table. Time and measures are always displayed in the table, although you can switch their places so that measures are displayed across and time is displayed down. For more information, see About report layout options
You can limit the information in a report based on criteria of data in a particular column.
Example If you limit column one to display all values greater than 5,000,000, any rows with values less than 5,000,000 in that column are not displayed.
You can order dimensions and members by a specific column, alphabetically, or hierarchically.
When Show Parents is selected, each level of the dimension is indented when you drill up or down. The indentation is removed if you sort on a column or if you order the dimension alphabetically.
You can control whether all higher levels of a dimension are displayed when drilling down.
You can display a Grand Total row that represents the sum of all the numbers in each column for each page in the report. If the column is a percentage, such as % Variance, then the total number in that column represents the total percent variance rather than the sum. One page is considered one combination of members when there are two or more dimension members down the page. A table can have a single page down, or it may have multiple pages down the table.
You can include a % Total row at the bottom of the report that represents the percentage of contribution of that column's members to the total for each page of the report.
You can display a Total column across the report that sums the values across each row. If there are more than two dimensions across the table, then a column of subtotals is also shown for each page across the table. If the row is a percentage, then the total number in that row represents the total percent variance rather than the sum.
You can include a % Total row across the report that represents the percentage of contribution of row members to the total for each page across the report. You can use this feature only if you have one dimension or metric displayed across the report.