Using Calculations
Calculations are basic to solving problems and
making decisions, and can help you to define the relationships between
items of interest. For example, calculations such as rank and percentile
help you instantly identify the most significant items in your analysis.
In IBM® Cognos® Analysis Studio, you can specify which subtotals to show and can view summaries and calculations without typing complex expressions.
The calculations available depend on how many columns or rows you select before you click Calculate.
| Objects selected | Available calculations |
|---|---|
| A single row or column | rank, show values as a percentage of the total, round or round down values, and show absolute values |
| Two rows or columns | arithmetic and percentage calculations |
| Three or more rows or columns | aggregate calculations, such as sum, average, maximum, and minimum |
| A set | all calculations in the Calculate dialog box |
You can perform calculations in IBM Cognos Analysis Studio by using predefined summaries or item-based calculations.