Filter
Top Products
CHAPTER 12 Working with Crosstabs
DataWindow Designer User’s Guide 341
❖ To specify an expression for columns, rows, or values:
1 In the Crosstab Definition dialog box (or wizard page), double-click the
item in the Columns, Rows, or Values box.
The Modify Expression dialog box displays.
2 Specify the expression and click OK.
Viewing the crosstab
After you have specified the data for the crosstab’s columns, rows, and values,
DataWindow Designer displays the crosstab definition in the Design view.
For example, to create the dynamic crosstab shown as the “Dynamic crosstab
example” on page 339, you would:
1Drag the
quarter column from the Source Data box to the Columns box.
2Drag the
product column from the Source Data box to the Rows box.
3Drag the
units column from the Source Data box to the Values box and
accept the expression
sum(units for crosstab).
4 Select the Rebuild Columns at Runtime check box.