Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 659

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 count of the

employee counts (the first expression):

CrosstabCount(1)

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

salary totals (the second expression):

CrosstabCount(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 count of the sales for each

year:

CrosstabCount(1, 2, "@year")

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

row:

CrosstabCount(1)

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

creating computed fields using the Crosstab functions, see

CrosstabAvg.