Aggregation Options
The table below lists the available crosstab aggregation measures. You can choose to display univariate aggregations (e.g., 'Sum', 'Count') as a percentage value by selecting the percentage basis (e.g., 'Group', 'GrandTotal') from the accompanying 'Percentage of' menu.
For the bivariate aggregation methods (e.g., 'Correlation', 'Weighted Average'), you will need to select a variable (column) to use as the second operand in the computation. Make this selection in the menu labeled 'with'.
Table 1. Aggregation Measures.
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'. |
See Also
Percentage Representation for Aggregation, to display crosstab data as a percentage.
| << Aggregation Example | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.3.4 Percentage Representation for Aggregation >> |