Brio Software
Technical Publications
Home Previous Next Index Glossary
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.

*

Note   You can only apply an increase formula at the innermost dimensional level of a Pivot report.

To calculate an increase item:

  1. Select a side or top dimension item as a break to define where to add the increase item.
  2. Click the Summation button on the Standard toolbar.
  3. A total item appears in the display, broken by the selected dimension item. You will convert the new total item to an increase item.

  4. Press the modifier key - (Alt for Windows, Option for Mac, or CTRL-alt for Motif), and click to select the individual total row or column.
  5. On the shortcut menu, select a function to apply from the Data Function submenu.
  6. The column is re-calculated to reflect the increase.


Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.