active content advanced options

Create a Simple Calculation

You can select items in your report and create simple calculations.

In addition to simple arithmetic calculations, you can perform the following calculations:

Calculation	Description
Rollup	Summarizes, or rolls up, all the values in a hierarchy.
%	Calculates the value of a selected item as a percentage of another item.
% Growth	Calculates the difference between two items as a percentage.
% Of Base	This calculation is only available if you select two members from different hierarchies, each from a different edge. This calculation takes the first selected member from edge A and the second selected member from edge B. The calculation result of a percent of base should be such that all the values for member A will compare itself to the intersect value of member A and B.
Custom	Allows you to specify your own value when performing a simple arithmetic calculation. Also allows you to change the order of operands or type a custom name for the new calculated row or column.

Procedure

Select the items in your report to calculate.
Click the insert calculation button and select the calculation to perform.
Tip: Calculations that are not applicable to the items you selected are greyed out.
To change the order of the operands, the name of the calculated item added to the report, or to create a custom calculation, click Custom.

Results

The calculation appears as a new row or column in your report.