How to edit totals

You edit totals when you want to change the way that they behave. For example, to change where a total is displayed on the worksheet.

To edit 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 Edit to display the "Edit Total dialog".

5. Edit the total details as required.

6. Click OK to save the details and close the Edit Total dialog.

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

Discoverer refreshes the worksheet.

Notes

• You can also edit totals in the following way:

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

• You can change the format of totals on a worksheet using Format | Item Formats to display the "Format dialog". Then, select the total from the item list and choose Format Heading or Format Data.