---

New Percentage dialog

Use this dialog to create a 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 drop down list to select which item you want to base your percentage on. The list displays numeric items available in the worksheet.

Calculate as a percentage of:

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.

Example

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).

Label

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.

Label

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.

Format Data

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.

Format Heading

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.

Label

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.

Format Data

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.

Format Heading

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.