Databases Reference
In-Depth Information
The Crosstable wizard only requires us to set three parameters, as shown below:
• Number of
Qualifier Fields
: Here, we specify the number of columns which
precede the table Data Area (where the amounts are). In our case, there is
only one Qualifier field:
Department
.
•
Attribute field
: This parameter is used to assign a name to the field that will
hold the new dimension values resulting from the transformation. For this
example, we will , set it to
Month
.
•
Data Field
: This indicates the name of the field that will hold the data values
resulting from the transformation. We will name it
Sales
.
After clicking on
OK
, the
Result
tab, at the lower pane of the
File Wizard
window,
will show a preview of the transformed table: