How to edit percentages

You edit percentages to change the way that they behave. For example, you might want to change a grand total percentage to a subtotal and grand total percentage.

To edit a percentage:

1. Display the worksheet that you want to analyze.

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

   
   Description of the illustration tot5.gif
   
   

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

3. Select a percentage in the Available list.

4. Click Edit to display "Edit Percentage dialog".

5. Edit the percentage details as required.

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

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

   Discoverer refreshes the worksheet.

Notes

• You can also edit percentages in the following way:

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