Table / Crosstab Layout page

This page is displayed when you click the Layout and More links at the top of a worksheet.

This page enables you to rearrange items on a table or crosstab using either the Layout tool or the arrow icons. This page also enables you to specify whether to show or hide page items.

Layout

The Layout tool enables you to rearrange table or crosstab items using the drop down lists.

Use the drop down lists to select values that determine whether to move a selected table or crosstab item or swap one item with another, and where and what to move or swap. You can continue to move or swap table or crosstab items using the drop down lists until you have achieved an acceptable table or crosstab layout.

For more information about using the drop down lists on this page, see the description under the Layout heading in "Worksheet Display page: (Table/Crosstab tools)".

Show Page Items

Use this check box to show or hide page items in the worksheet.

Use the arrow icons as an additional method of rearranging worksheet items.

Discoverer Viewer displays the arrow icons in a sample layout that indicates the relative positions of worksheet page items, column headers, and rows when you have made changes to the table or crosstab layout.

Use the arrow icons to do the following (for both tables and crosstabs):

move a page item to a column
move a column to a page item
move a column to the right or to the left of the adjacent column

Use the arrow icons to do the following (for crosstabs only):

move a page item to a row
move a page item to a column
move a measure (e.g. Profit Sum, Cost) to a page item
move a measure (e.g. Profit Sum) to a row
move a measure (e.g. Profit Sum) to below the adjacent column
move a column to a row
move a column to above the adjacent column
move a column to below the adjacent column

When you are satisfied with the layout of your table or crosstab, click Apply to display the table or crosstab using the settings you have just specified.