Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

Percent Contribution dialog

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"

"Reporting function examples"

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