Skip Headers

Oracle9iAS Discoverer Plus User's Guide
Version 9.0.2

Part Number A90879-02
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

New Percentage dialog

Use this dialog to create a new percentage item. For example, you might want to analyze the worksheet in a new way by calculating your monthly sales as a percentage of annual sales.

For more information, see:

"What are percentages?"

What do you want to name this percentage?

Use this field to enter a descriptive name for the percentage item. This name is displayed in percentage lists and on worksheets as the column header of the percentage item. If you leave this box blank, Discoverer creates a default name for you.

What data point do you want to base your percentage on?

Use this pull down list to select which item you want to base your percentage on. The list displays numeric items available to the worksheet.

Calculate as a percentage of:

Use these radio buttons to choose how the percentage is calculated.

Which page items do you want to include?

Use these radio buttons to choose the scope of your percentage.

Example

This area shows you how your worksheet will look according to what options you specify.

Which totals do you want to be shown?

Use these options to specify how you want totals and sub totals to be displayed.

Show grand total and grand total percentage?

Use this check box to display a sum of all values and a sum of the percentages (specific to the Grand total for all values option).

Label

Use this field to define the grand total percentage label that will appear on the worksheet (if selected). To enter a different label, click the down arrow to the right of the field. To format the label, click the Format button and choose how you want the label to look on the worksheet.

Show subtotals and subtotal percentage

Use this check box to display a subtotal for values in the item group, and a percentage for the subgroup (specific to the Subtotal at each change in option).

Label

Use this field to define the subtotal percentage label that will appear on the worksheet (if selected). To enter a different label, click the down arrow to the right of the field. To format the label, click the Format button and choose how you want the label to look on the worksheet.

Show the percentage of the grand total for each subtotal

Use this check box to display a subtotal as a percentage of the grand total.

Label

Use this field to define the grand total percentage label that will appear on the worksheet (if selected). To enter a different label, click the down arrow to the right of the field. To format the label, click the Format button and choose how you want the label to look on the worksheet.

Format Data

Use this button to display the "Format Data dialog", where you change how the item values look on the worksheet.

Format Heading

Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index