Defining summary statistics

When you generate a crosstab, the columns and rows are automatically totaled for you. You can include other statistical summaries in crosstabs as well. To do that, you place computed fields in the workspace.

To define a column summary:

Enlarge the summary band to make room for the summaries.
Select Insert>Control>Computed Field from the menu bar.
Click the cell in the summary band where you want the summary to display.

The Modify Expression dialog box displays.
Define the computed field.

For example, if you want the average value for a column, specify avg(units for all), where units is the column providing the values in the crosstab.

For example, this is a crosstab that has been enhanced to show averages and maximum values for each column. This is the Design view:

Shown is the Design view with Average and Maximum calculations.

This is the crosstab at runtime:

Shown is the output of the cross tab defined in the previous illustration, with averages and maximums.

To define a row summary:

Select Insert>Control>Computed Field from the menu bar.
Click the empty cell to the right of the last column in the detail band.

The Modify Expression dialog box displays.
Define the computed field. You should use one of the crosstab functions, described next.