How to display or hide percentages

If a worksheet contains existing percentages (e.g. percentages created by other Discoverer users, or created by the Discoverer manager) you can display or hide the percentages on the worksheet.

You display or hide the percentages as follows:

• display percentages on a worksheet to use them to analyze worksheet data

• hide percentages on a worksheet to not use them to analyze worksheet data

To display or hide 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. To display an existing percentage, move the percentage from the Available list to the Selected list.

4. To hide an existing percentage, move the percentage from the Selected list to the Available list.

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

Discoverer refreshes the worksheet according to the options selected.

Notes

• You can also display existing percentages in the following way:

  • If the Available Items pane is displayed, drag and drop a percentage from the Calculations tab to the worksheet.

• You can also hide percentages in the following way:

  • If the Selected Items pane is displayed, right-click on a percentage in the Selected Items list and select Remove from Worksheet.

• To remove a percentage from the worksheet permanently, you delete the percentage (for more information, see "How to delete percentages").