Specifications

CrosstabSum

666 InfoMaker

For more information about restricting the calculation to groups of values when

the crosstab definition has more than one column, see Usage for

CrosstabAvg.

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 These examples all use the crosstab-values expressions shown below:

Count(emp_id for crosstab),Sum(salary for crosstab)

This expression for a computed field in the crosstab returns the sum of the

employee counts (the first expression):

CrosstabSum(1)

This expression for a computed field in the crosstab returns the sum of the

salary totals (the second expression):

CrosstabSum(2)

The next two examples use a crosstab with two columns (year and quarter), a

row (product), and the values expression Avg(sales for crosstab).

This expression for a computed field returns the sum of the quarterly average

sales for each year:

CrosstabSum(1, 2, "@year")

This expression for a computed field returns the sum of all the average sales in

the row:

CrosstabSum(1)

For an example illustrating how the painter automatically defines a crosstab by

creating computed fields using the Crosstab functions, see

CrosstabAvg.