Summarizations and Tabulations  Perform a cross tabulation  
The Type of Summary dropdown in the Cross Tabulation dialog contains a number of summarizations.
number of records  The number of rows in each group.

% of total records  The number of rows in each group as a percentage of all rows.
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of total records  The number of rows in each group as a fraction of all rows.
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of # records  The rank of each group, in terms of its number of records, with respect to all
other groups.

% of row records  The number of records in each group as a percentage of the total number of
records on the same row of the cross tabulation result.
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of row records  The number of records in each group as a fraction of the total number of records
on the same row of the cross tabulation result.
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of #records in row  The rank of each group, in terms of its number of records, with respect to the
other groups on the same row of the cross tabulation result.

% of column records  The number of records in each group as a percentage of the total number of
records in the same column of the cross tabulation result.
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of column records  The number of records in each group as a fraction of the total number of records
in the same column of the cross tabulation result.
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of #records in column  The rank of each group, in terms of its number of records, with respect to the
other groups in the same column of the cross tabulation result.

number of unique values  The number of unique values in the Column for each
group.

sum  The subtotal of the Column for each group. (numeric
columns only)

% of grand total  The subtotal of the Column for each group as a percentage
of the grand total. (numeric columns only)
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of grand total  The subtotal of the Column for each group as a fraction of
the grand total. (numeric columns only)
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of sum  The rank of each group, in terms of its Column subtotal,
with respect to the other groups. (numeric columns only)

% of row total  The subtotal of the Column for each group as a percentage
of the total for that row of the cross tabulation result. (numeric columns
only)
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of row total  The subtotal of the Column for each group as a fraction of
the total for that row of the cross tabulation result. (numeric columns only)
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of sum in row  The rank of each group, in terms of its Column subtotal,
within that row of the cross tabulation result. (numeric columns only)

% of column total  The subtotal of the Column for each group as a percentage
of the total for that column of the cross tabulation result. (numeric columns
only)
Note: The result is a whole number, not a fractional value. For instance, a result of
20% would be represented as 20, not 0.20.

fraction of column total  The subtotal of the Column for each group as a fraction of
the total for that column of the cross tabulation result. (numeric columns
only)
Note: The result is a fractional value. For instance, a result of 20% would be
represented as 0.20.

rank of sum in column  The rank of each group, in terms of its Column subtotal,
within that column of the cross tabulation result. (numeric columns only)

average  The average of the Column for each group. (numeric
columns only)

rank of average  The rank of each group, in terms of its Column average,
with respect to the other groups. (numeric columns only)

rank of average in row  The rank of each group, in terms of its Column average,
within that row of the cross tabulation result. (numeric columns only)

rank of average in column  The rank of each group, in terms of its Column average,
within that column of the cross tabulation result. (numeric columns only)

weighted average  The average of the Column, weighted by
the Reference Column, for each group. (numeric columns
only)

highest number  The highest number in the Column for each group.
(numeric columns only)

lowest number  The lowest number in the Column for each group.
(numeric columns only)

first value  The first value in the Column for each group.
(alphanumeric and numeric columns) This is the first value based on the current sort order of the table (i.e., the way the data is shown when the table is viewed multiple rows at a time).

last value  The last value in the Column for each group. (alphanumeric and numeric
columns) This is the last value based on the current sort order of the table (i.e., the way the data is shown when the table is viewed multiple rows at a time).

standard deviation  The standard deviation of the Column for each group.
(numeric columns only)

variance  The variance of the Column for each group. (numeric
columns only)

weighted std dev  The standard deviation of the Column, weighted by
the Reference Column, for each group. (numeric columns
only)

weighted variance  The variance of the Column, weighted by
the Reference Column, for each group. (numeric columns
only)

sum of squares  The sum of squares of the Column for each group.
(numeric columns only)

correlation  The correlation of the Column and the Reference
Column, for each group. (numeric columns only)

covariance  The covariance of the Column and the Reference
Column, for each group. (numeric columns only)

dot product  The dot product of the Column and the Reference
Column, for each group. (numeric columns only)

number of valid values  The number of nonN/A values in the Column for each group. 
number of N/As  The number of N/A values in the Column for each group. 
number of valid pairs  The number of rows where both the Column and the Reference Column are not N/A, for each group. 
number of N/A pairs  The number of rows where either the Column or the Reference Column is N/A, for each group. 
median  The median of the Column for each group. (numeric
columns only)

mode  The mode of the Column for each group. (numeric columns
only)

frequency of mode  The frequency of the mode of the Column for each group.
(numeric columns only)

number of modes  The number of modes in the Column for each group.
(numeric columns only)
