Use this dialog to change the way that the currently selected percentage item behaves. For example, you might want to changes its name, description, or how it is calculated.
For more information, see:
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 drop down list to select which item you want to base your percentage on. The list displays numeric items available in the worksheet.
Use these options to choose how the percentage is calculated.
Grand total of all values
Use this option to calculate a percentage of all values.
Grand total for each column
Use this option 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.
Grand total for each row
Use this option 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.
Subtotal for each change in
Use this option to calculate a percentage for a sub-group. Select an item from the drop down list below to define the item you want to sub-group. For example, to calculate a percentage total for each calendar year, you might choose 'Year' here.
Do you want to calculate percentages within each page?
Use these options to choose whether to calculate the percentage for each page, or for all pages.
Note: You only use these options if the worksheet has page items.
Calculate percentages with each page
Use this option 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.
Calculate percentages across all pages
Use this option 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 looks according to the 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).
Use this field to define the grand total percentage label that appears 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.
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).
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 appears 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.
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.
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 appears 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.