Specifications

CrosstabAvg
656 InfoMaker
What the function arguments mean
When the crosstab definition has more
than one column, you can specify column qualifiers for any of the
Crosstab
functions, so that the crosstab displays calculations for groups of column
values. As illustrated previously, when year and quarter are the columns in the
crosstab, the expression for the computed field is:
CrosstabAvg(1, 2, "@year")
The value 2 refers to the quarter column (the second column in the Crosstab
Definition dialog) and “@year” specifies grouping values from the year
column (meaning the function will average values for the quarters within each
year). The value 1 refers to the crosstab-values expression that will be
averaged. In the resulting crosstab, the computed field repeats in each row after
the cells for the quarters within each year.
Tips for defining crosstabs When you define a crosstab with more than one
column, the order of the columns in the Columns box of the Crosstab
Definition dialog box governs the way the columns are grouped. To end up
with the most effective expressions, make the column that contains the
grouping values (for example, year or department) the first column in the
Columns box and the column that contains the values to be grouped (for
example, quarter or employee) second.
To display calculations for groups of rows, define groups as you would for
other report presentation styles and define computed fields in the group header
or footer using noncrosstab aggregation functions, such as
Avg, Sum, or Max.
Reviewing the expressions
To review the expressions defined for the crosstab values, open the Crosstab
Definition dialog box (select Design>Crosstab from the menubar).
Examples The first two examples use the crosstab expressions shown below:
Count(emp_id for crosstab),Sum(salary for crosstab)
This expression for a computed field in the crosstab returns the average of the
employee counts (the first expression):
CrosstabAvg(1)
This expression for a computed field in the crosstab returns the average of the
salary totals (the second expression):
CrosstabAvg(2)