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 calculation using an analytic function template"
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 the groups to be used 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.
This read-only field displays the underlying formula that you are building as you specify values for the fields above. This formula is updated each time you change one of the values in the fields above. When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".
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".