Edit Worksheet dialog: Totals tab

Use this tab to specify how total items are displayed on the current worksheet. This tab displays a list of existing totals available to the worksheet. Use this tab to:

• display and hide existing worksheet totals

• manage existing totals

• create new totals

For more information, see:

"What are totals?"

View totals for

Use this list to limit the totals that are displayed in the list below. The default setting displays totals for all items, which lists all totals available to the current worksheet.

• To display a total in the current worksheet, select the check box beside the total that you want to display.

• To hide a total, clear the check box next to the total that you want to hide.

New

Use this button to display the New Totals dialog (see "New Total dialog (on a table worksheet)" or "New Total dialog (on a crosstab worksheet)"). Use the appropriate New Total dialog to create new totals.

Edit

Use this button to display the Edit Totals dialog (see "Edit Total dialog (on a table worksheet)" or "Edit Total dialog (on a crosstab worksheet)"). Use the appropriate Edit Totals dialog to edit the total selected in the list.

Delete

Use this button to permanently remove the selected total.

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")

Notes:

• To remove a total from a worksheet without deleting the total, hide the total using the View totals for drop down list.

• You are not allowed to delete Totals created for you by the Discoverer manager.