Oracle Application Server Discoverer Plus User's Guide 10g (9.0.4) Part Number B10268-01 |
|
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:
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.
Use this drop down list to select which item you want to base your percentage on. The list displays numeric items available to the worksheet.
Use these radio buttons to choose how the percentage is calculated.
Use this radio button to calculate a percentage of all values.
Use this radio button to calculate a percentage for the item column (specific to crosstab worksheets).
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this radio button to calculate a percentage for the item row (specific to crosstab worksheets).
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this radio button to calculate a percentage for a sub-group. Select an item from the drop down list below to define the item that you want to sub-group. For example, to calculate a percentage total for each calendar year, you might choose 'Year' here.
Use these radio buttons to choose whether to calculate the percentage for each page, or for all pages.
Note: You only use these radio buttons if the worksheet has page items.
Use this radio button to calculate percentages for data on the current page. For example, if Region is displayed in the Page Items area, you might want to calculate how sales for each quarter contribute to total sales for the each region.
Use this radio button to calculate percentages for all pages. For example, if Region is displayed in the Page Items area, you might want to calculate how sales for each quarter contribute to total sales for the all regions.
This area shows you how your worksheet will look according to what options you specify.
Use these options to specify how you want totals and sub totals to be displayed.
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).
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 on 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.
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).
Note: This field is only displayed when you add a total to a crosstab worksheet.
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 on 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.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this button to display the "Format Data dialog", where you change how the values look on the worksheet.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this check box to display a subtotal as a percentage of the grand total.
Note: This field is only displayed when you add a total to a crosstab worksheet.
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 on 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.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this button to display the "Format Data dialog", where you change how the values look on the worksheet.
Note: This field is only displayed when you add a total to a crosstab worksheet.
Use this button to display the "Format heading dialog", where you change how the item headings look on the worksheet.
Note: This field is only displayed when you add a total to a crosstab worksheet.
|
![]() Copyright © 1999, 2003 Oracle Corporation. All Rights Reserved. |
|