How to delete percentages

You delete a percentage when you no longer want to use it, and want to permanently remove it from a workbook. For example, you might have created a temporary percentage to produce an ad hoc report and now want to remove the percentage from the workbook.

To delete 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 Delete.

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

   Discoverer refreshes the worksheet.

If the deleted percentage was previously displayed on the worksheet, Discoverer removes the percentage information from the worksheet display pane.

Notes

• You can also delete percentages in the following way:

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

• To remove a percentage from the worksheet without deleting the percentage permanently, you can hide the percentage (for more information, see "How to display or hide percentages").

• If the deleted percentage was used to sort a worksheet, the sorting is removed and the items revert to the default order.