Special Values for Summary Table

columnProportion

These special values are available only for formulas in a summary table, and they appear in the Special heading, not in the Functions list. This is the proportion of cases in a column of a summary table that belong in a cell.

columnTotal

The number of cases in a column of a summary table.

expected

The expected number of cases for a cell in a two-way table.

grandTotal

The total number of cases that appear in a summary table.

Note: This may not be the same as the total number of cases in the collection, because some cases in the collection may not have the requisite values to show themselves in the summary table.

rowProportion

The proportion of cases in a row of a summary table that belong in a cell.

rowTotal

The number of cases in a row of a summary table.