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.

• Grand total of all values

  Use this radio button to calculate a percentage of all values.

• Grand total for each column

  Use this radio button to calculate a percentage for the item column (specific to crosstab worksheets).

• Grand total for each row

  Use this radio button to calculate a percentage for the item row (specific to crosstab worksheets).

• Subtotal for each change in

  Use this radio button to calculate a percentage for a sub-group. Select an item from the pull 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.

Which page items do you want to include?

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

• Calculate percentages only for the current page item

  Use this radio button to apply the percentage to data displayed on the worksheet.

• Calculate percentages only for all page items

  Use this radio button to apply the percentage to all data in the worksheet. Here, data for other page items not selected is also included.

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.