6.3.3 Crosstab Aggregation Measures
The table below shows the crosstab aggregation measures available for table grouping.
Aggregate Measure |
Description |
Sum |
Displays the sum of the measure values for the given row and column headings |
Average |
Displays the average of the measure values for the given row and column headings |
Max |
Displays the maximum of the measure values for the given row and column headings |
Min |
Displays the minimum of the measure values for the given row and column headings |
Count |
Displays the total count of measure values for the given row and column headings. This represents the total number of records corresponding to the given row and column headings, and is the same value for any selected measure. |
Distinct Count |
Displays the count of unique measure values for the given row and column headings. |
Correlation |
Displays the Pearson correlation coefficient for the correlation between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'. |
Covariance |
Displays the covariance between the measure values (for the given row and column headings) and the corresponding values in a second column, specified by the menu labeled 'with'. |
Variance |
Displays the (sample) variance of the measure values for the given row and column headings. |
Std Deviation |
Displays the (sample) standard deviation of the measure values for the given row and column headings. |
Variance (Pop) |
Displays the (population) variance of the measure values for the given row and column headings. |
Std Deviation (Pop) |
Displays the (population) standard deviation of the measure values for the given row and column headings. |
Weighted Average |
Displays the weighted average of the measure values for the given row and column headings. The weights are given by the corresponding values in a second column, which is specified by the menu labeled 'with'. |
Suppose that you want to know the total amount of money spent by each customer on each of the products. Follow the steps below to display that information in a crosstab table:

1. Create a new Worksheet.
2. Expand the 'Data Source' node, and the 'Orders' node.
3. Drag the 'Order details' query on to an empty cell in the Worksheet. This creates a new table named 'Order details1'.
4. Press the 'Group and Aggregate' button in the table's title bar. This opens the 'Aggregate' dialog box.

5. Click on the 'Switch to Crosstab' button. The view changes to enable you to specify the column headers and the summary column.
6. Select 'Company' from the first drop-down list under the 'Row Header'.
7. Select 'Product' from the 'Column Header' drop-down list.
8. Select 'Total' from the 'Measure' drop-down list and ensure that the aggregate function is set to 'Sum'.

9. Click on the 'OK' button to save the changes.
10. Preview the table.

| << 6.3.2 Defining a Crosstab Table | © 1996-2013 InetSoft Technology Corporation (v11.5) | 6.3.4 Switching Between Detail and Aggregate View >> |