Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

15 Using percentages

This chapter explains how to use Discoverer Plus Relational's percentages to answer typical business questions. For example, what is the sales total for January as a percentage of the annual sales total? This chapter contains the following topics:

15.1 What are percentages?

Percentages are worksheet items that enable you to quickly and easily calculate percentages of rows and columns. For example, to calculate monthly profit figures as a percentage of the annual profit figure.

The figure below shows a worksheet containing a percentage item called 'Percentage of annual profit'. From this column you can see that the Video Rental department in the Central region contributed 8% of the annual profit total (that is, $25,157).

Figure 15-1 A Discoverer worksheet with a percentage item (Percentage of annual profit)

Surrounding text describes Figure 15-1 .

Notes

15.2 How to display or hide percentages

If a worksheet contains existing percentages (for example, 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:

To display or hide a percentage:

  1. Display the worksheet you want to analyze.

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

    Surrounding text describes tot5.gif.

    The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active percentages are marked with a checkmark 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

15.3 How to create percentages

You create percentage items to analyze a worksheet in a new way. For example, you might want to display monthly sales figures as a percentage of the annual sales figures.

Worksheets can also contain percentages created by other Discoverer users, or created by the Discoverer manager.

To create a percentage:

  1. Display the worksheet you want to analyze.

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

    Surrounding text describes tot5.gif.

    The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active percentages are marked with a checkmark in the Available list and are also displayed in the Selected list.

  3. Click New and select New Percentage from the drop down list to display the "New Percentage dialog".

  4. (optional) To change the default name of the new percentage, enter the name in the What do you want to name this percentage? field.

  5. Use the Which data point do you want to base your percentage on? drop down list to specify which item to create a percentage for.

    The drop down list displays numeric items currently displayed on the worksheet. If there is only one numeric item on the worksheet, this item is selected by default.

  6. Use the Calculate as a percentage of options to choose where to display the percentage, as follows:

    • Select the Grand total of all values option to calculate the values as a percentage of the whole column.

    • Select the Subtotal at each change in option, then choose the item on which to group the data from the drop down list below.

      For example, if the worksheet data is grouped by region, select region here to calculate a percentage sub-total for each region.

  7. Use the Do you want to calculate percentages within each page? options to choose whether to calculate percentages for each page, or for all pages.

  8. Use the Which totals do you want to be shown? check boxes to specify how to display grand totals and subtotals.

    The options available depend on whether you have selected the Grand total of all values option, or the Subtotal at each change in option.

    • (optional) If you selected the Grand total of all values option, select the Show grand total and grand total percentage check box to calculate total values at the bottom of the worksheet.

      You can also specify a label for the total, and click Format Heading and Format Data to specify how it looks on the worksheet.

    • (optional) If you selected the Subtotal at each change in option, select the Show subtotal and subtotal percentage check box to calculate subtotal values for each data sub-group.

    • (optional) If you selected the Subtotal at each change in option, select the Show the percentage of the grand total for each subtotal option to display the sub-group total as a percentage of the total value for all groups.

  9. Click OK to save the details and display the Percentages dialog.

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

Discoverer calculates the percentages and displays them on the worksheet.

Notes

15.4 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 you want to analyze.

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

    Surrounding text describes tot5.gif.

    The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active percentages are marked with a checkmark 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

15.5 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 you want to analyze.

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

    Surrounding text describes tot5.gif.

    The Calculations tab lists existing calculations, percentages, and totals available in the worksheet. Active percentages are marked with a checkmark 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