Filter
Top Products
CHAPTER 12 Working with Crosstabs
DataWindow Designer User’s Guide 349
Using crosstab functions
There are nine special functions you can use only in crosstabs: CrosstabAvg,
CrosstabAvgDec, CrosstabCount, CrosstabMax, CrosstabMaxDec, CrosstabMin,
CrosstabMinDec, CrosstabSum, and CrosstabSumDec.
These functions are listed in the Functions box when you define a computed
field in a crosstab:
Each of these functions returns the corresponding statistic about a row in the
crosstab (average, count, maximum value, minimum value, or sum). You place
computed fields using these functions in the detail band in the Design view.
Use the functions with the
Dec suffix when you want to return a decimal
datatype.
By default, DataWindow Designer places
CrosstabSum and CrosstabSumDec
in the detail band, which returns the total for the corresponding row.
How to specify the
functions
Each of these functions takes one numeric argument, which refers to the
expression defined for Values in the Crosstab Definition dialog box. The first
expression for Values is numbered 1, the second is numbered 2, and so on.
Generally, crosstabs have only one expression for Values, so the argument for
the crosstab functions is 1. So, for example, if you defined
sum(units for
crosstab)
as your Values expression, DataWindow Designer places
CrosstabSum(1) in the detail band.
If you want to cross-tabulate both total unit sales and a projection of future
sales, assuming a 20 percent increase in sales (that is, sales that are 1.2 times
the actual sales), you define two expressions for Values:
sum(units for crosstab)
sum(units * 1.2 for crosstab)