Summarization options in the grid menu

The grid menu provides a list of common calculations, called summarizations, from which to choose when creating a quick summary directly in the grid.

You can choose from the following types of summarizations when performing a quick summary in the grid.
Note: In the list below, [COLUMN] indicates either the column name or the column label of the selected column. By default, the column label is displayed. However, when the Show with column names option is selected in the Tabulation panel, the column name is displayed instead.
Figure 1. Grid menu summarization options
sum
The subtotal of the column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the sum of the non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
Note: This option adds the sum of [COLUMN] tabulation function field to the lower area of the Column Breaks section in the Tabulation panel.
average
The average of the column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the average of the non-N/A values).
  • If a group contains only N/A values, the result for the group is N/A.
Note: This option adds the avg of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.
valid count
The number of non-N/A values in the column for each group.
Note: This option adds the valcnt of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.
N/A count
The number of N/A values in the column for each group.
Note: This option adds the nacnt of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.
unique count
The number of unique values in the column for each group.
  • If a group contains N/A values, those rows are ignored (i.e., the result is the number of unique non-N/A values).
  • If a group contains only N/A values, the result for the group is 0.
Note: This option adds the ucnt of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.
lowest value
The lowest number in the column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the lowest non-N/A value).
  • If a group contains only N/A values, the result for the group is N/A.
Note: This option adds the lo of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.
highest value
The highest number in the column for each group. (numeric columns only)
  • If a group contains N/A values, those rows are ignored (i.e., the result is the highest non-N/A value).
  • If a group contains only N/A values, the result for the group is N/A.
Note: This option adds the hi of [COLUMN] summarization to the lower area of the Column Breaks section in the Tabulation panel.