To specify how each dimension in the database should be represented in the spreadsheet report:
Drag the dimension to the desired location in the layout panel.
The Page Dimensions box specifies that dimensions are to be placed across the top of the spreadsheet.
The Column Dimensions box specifies that dimensions are to be placed in the columns of the spreadsheet.
The Row Dimensions box specifies that dimensions are to be placed in the rows of the spreadsheet.
You can also drag dimensions from one location to another within the navigation panel or between the navigation panel and the layout panel. Alternatively, you can select a dimension in the navigation panel, right-click, and select Move to.
You must specify at least one dimension for a row dimension and one for a column dimension.
If the database outline contains attribute dimensions, they are usually displayed under the Available Dimension list in the navigation panel. You can select dimensions from the Available Dimensions list and specify their layout in the report.