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

List totals for

Use this drop down list to specify which totals you display 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.

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

New

Use this button to display the New Totals dialog (see "New Total dialog"). Use the appropriate New Total dialog to create new totals.

Edit

Use this button to display the Edit Totals dialog (see "Edit Total dialog"). 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.