Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 661

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 maximum of

the employee counts (the first expression):

CrosstabMax(1)

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

the salary totals (the second expression):

CrosstabMax(2)

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

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

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

sales for each year:

CrosstabMax(1, 2, "@year")

This expression for a computed field returns the maximum of all the average

sales in the row:

CrosstabMax(1)

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

creating computed fields using the

Crosstab functions, see CrosstabAvg.