The settings in the Calculation priority area determine the order in which rows and columns are calculated. The following calculation priority options are available:

Calculate row calculation first and then column
Performs the row calculations before the column calculations. This option works the best in the following situations:

Report with a CALC column or with simple calculations

Row definition and column definition that use only simple mathematical operators (+ and )


Perform column calculation first and then row
Performs the column calculations before the row calculations. This option might be necessary when a column calculation (CALC) intersects a total (TOT) or calculation (CAL) row, and you want the row calculation to overwrite the column calculation.
To specify calculation priority, do the following:

In an open report definition, click the Settings tab.

Click a Calculation priority option.