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