Specifications

Associating data with a crosstab
440 InfoMaker
In the Design view, the crosstab looks like this:
Notice that in the Design view, InfoMaker shows the
quarter entries using the
symbolic notation
@quarter (with dynamic crosstabs, the actual data values
are not known at definition time).
@quarter is resolved into the actual data
values (in this case, Q1, Q2, Q3, and Q4) when the crosstab runs.
The crosstab is generated with summary statistics: the rows and columns are
totaled for you.
At this point, the crosstab looks like this in the Preview view with data
retrieved:
• Because
quarter was selected as the Columns definition, there is one
column in the crosstab for each unique quarter (Q1, Q2, Q3, and Q4).
• Because
product was selected as the Rows definition, there is one row in
the crosstab for each unique product (Cosmic, Galactic, and Stellar).
• Because
sum(units for crosstab) was selected as the Values
definition, each cell contains the total unit sales for the corresponding
quarter (the Columns definition) and product (the Rows definition).
• InfoMaker displays the grand totals for each column and row in the
crosstab.