How to delete totals

You delete totals when you no longer want to use them, and want to remove them permanently from a worksheet. For example, you might have created a temporary total to produce an ad hoc report and now want to remove this total from the worksheet.

Note: If you want to remove the total from the worksheet without deleting it permanently, you can hide the total (see "How to display or hide totals").

To delete a total:

1. Display the worksheet that you want to analyze.

2. Choose Tools | Totals to display the "Edit Worksheet dialog: Select Items tab: Calculations tab".

   
   Description of the illustration tot4.gif
   
   

   The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active totals are marked with a tick symbol (or check mark) in the Available list and are also displayed in the Selected list.

3. Select a total in the Available list.

4. Click Delete.

5. Click OK to close the Calculations tab and return to the worksheet.

Discoverer refreshes the worksheet.

Notes

• You can also delete totals in the following way:

  • If the Available Items pane is displayed, display the Calculations tab, right-click on a total, and select Delete.