Filter
Top Products
CHAPTER 12 Working with Crosstabs
DataWindow Designer User’s Guide 347
Example
For example, if you want the product column to be labeled Printer Model,
double-click
product in the Crosstab Definition dialog box and specify
printer_model in the New Name dialog box.
When the crosstab runs, you see this:
Defining summary statistics
When you generate a crosstab, the columns and rows are automatically totaled
for you. You can include other statistical summaries in crosstabs as well. To do
that, you place computed fields in the workspace.
❖ To define a column summary:
1 Enlarge the summary band to make room for the summaries.
2 Select Insert>Control>Computed Field from the menu bar.
3 Click the cell in the summary band where you want the summary to
display.
The Modify Expression dialog box displays.
4 Define the computed field.
For example, if you want the average value for a column, specify
avg(units for all), where units is the column providing the values in
the crosstab.