Example of percentages
Example 1: This example shows how to use the New Percentage dialog to create a new percentage, and how the percentage is displayed on a worksheet. In the figure below, you calculate the profit sum for each region and department as a percentage of total profit.
Key to figure:
a. The New Percentage dialog.
b. The name of the percentage item.
c. The item (column) on which the percentage is based.
d. The percentage type.
e. The scope of the percentage item. You can create percentages for the each page item, or all page items.
f. The percentage item (Percentage of annual profit) as it appears on the worksheet.
g. The percentage values calculated by Discoverer. For example, using the new percentage item you can see that the Video Rental department in the Central region generated 8% of total profit (i.e. $25,157).
Example 2: This example shows how to use the Edit Percentage dialog to produce percentage subtotals. In the figure below, you calculate a subtotal percentage value for each region. In other words, what percentage of profit does each department contribute to the region total.
Key to figure:
a. The
Subtotal at each change in option calculates the value as a percentage of all values in a sub-group. The groups are defined by a change in value in this item.
b. In this case, the value Region is selected, which calculates a percentage sub-total for each region.
c. The percentage item (Percentage of regional profit) as it appears on the worksheet.
d. For example, the Video Rental department in the Central region contributes 41% of the total profit for the Central region (i.e. $47,204). Notice that the percentages for each region add up to 100%.