Data Analysis and Reporting with Intelligence Clients

Calculating Column Increases
You can calculate the difference between the final two instances of a total column or row by applying the Increase and %Increase functions. For example, if a numeric data item is dimensioned by year and displays values for 2000, 2001, and 2002, as well as the final total column, you can apply the increase functions to the total column and calculate the incremental difference between each set of 2001 and 2002 column values. If the years are divided into quarters and totaled for each year, you can apply the increase functions to the total columns and calculate the incremental difference between the third and fourth quarters of each year.
To calculate an increase item:
 Select a side or top dimension item as a break to define where to add the increase item.
 Click the Summation button on the Standard toolbar.
A total item appears in the display, broken by the selected dimension item. You will convert the new total item to an increase item.
 Press the modifier key  (Alt for Windows, Option for Mac, or CTRLalt for Motif), and click to select the individual total row or column.
 On the shortcut menu, select a function to apply from the Data Function submenu.
The column is recalculated to reflect the increase.
