Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
Use this dialog to create a percent contribution calculation. A percent contribution calculation calculates how much each value contributes to the sum of a set of values, and expresses the ratio as a percentage. For example, you might want to know how each store in a group of stores contributes to annual profits.
This type of analysis is sometimes referred to as reporting analysis.
For more information, see:
"What are analytic functions?"
"How to create a new calculation using an analytic function template"
Percent contribution on
Use this drop down list to choose the item for which you want to calculate the percent contribution. For example, you might choose Sales SUM to calculate a percent contribution of sales values.
Restart percent contribution at each change in
Use this list to specify which groups to use if you want to arrange results into groups (sometimes referred to as partitions).
For example, if you have Sales SUM values for each store and you want to calculate the percentage contribution for each store in relation to annual profits, you might choose Calendar Year.
If you do not specify a group, Discoverer treats all worksheet values as a single group.
Calculation
calculation When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".
Notes
Discoverer uses an underlying RATIO_TO_REPORT() function for this calculation.
For more information about calculating how running totals contribute to their group's total, see "Percent Running Contribution dialog".