6.3.2 Defining a Crosstab Table

A crosstab table is also known as a pivot table. A Worksheet crosstab contains one column header, one or more row headers, and one measure.

The values at the row-column intersections of the crosstab table represent summary (aggregate) information of the measure. For example, a crosstab with row headers representing 'Salesperson' and column headers representing 'Month of Year' might contain values at the intersections representing 'Average Sale Price' or 'Maximum Sale Price'. The measure in both cases is 'Sale Price'. The summarization method is, respectively, Average or Maximum. By using summarization, crosstab tables display large amounts of data in a compact form.

To create a crosstab table from an existing Data Table, follow these steps.

1. Press the 'Group and Aggregate' button in the table title bar. This opens the 'Aggregate' dialog box.

2. In the 'Aggregate' dialog box, click 'Switch to Crosstab'. The 'Aggregate' dialog box switches to the crosstab view.

 

3. In the 'Row Header' panel, select one or more fields from the left menus.

4. In the 'Column Header' panel, select a field from the left menu.

5. (Optional) For each selected field in the 'Row Header' and 'Column Header' panels, select a Named Grouping (if one exists) from the corresponding right menu.

6. In the 'Aggregate' panel, select a measure column from the left menu. This is the column whose values will be summarized.

7. In the 'Aggregate' panel, select the aggregation method from the right menu.

If you select a bivariate aggregation measure (e.g., 'Correlation', 'Weighted Average', etc.), select the second operand (column) from the 'with' menu.

8. (Optional) To display the measure as a percentage of the grant total, select the 'Percentage' option.

9. Click 'OK' to create the crosstab table.

See Also

Creating a Named Grouping, for more information on user-defined groupings.

Crosstab Aggregation Measures, for more details about aggregation methods.

Switching Between Detail and Aggregate View, to revert back to ungrouped table.

<< 6.3.1 Grouping and Aggregating Data © 1996-2013 InetSoft Technology Corporation (v11.5) 6.3.3 Crosstab Aggregation Measures >>