Edit Worksheet dialog: Crosstab layout tab

Use this tab to change the layout of the current worksheet. This is also known as pivoting. For example, you might want to change which items are displayed, and their position on the worksheet.

Note: This dialog is also known as Duplicate as Crosstab dialog: Crosstab Layout tab

For more information, see:

"About pivoting worksheet data"

Show page items

Use this check box to display page items on the worksheet.

Page Items area

This area shows which items are displayed in the Page Items area on the worksheet.

Layout Area

This area shows how the items are arranged.

• To change an item's position, click the item and drag and drop it to a new location. To help you position items, as you move an item round the worksheet a black line is displayed showing its new location.

• To remove an item, click the item and press Delete.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

• how Discoverer handles queries (see "Options dialog: Query Governor tab")

• how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")