The tabulation function field defines the calculation, called a summarization, in a
quick summary, tabulation, or cross tabulation. Change the summarization to select the type
of calculation you want to perform.
When a column biscuit is dragged into the lower area of the Column
Breaks section, a tabulation function is created for that column. By
default, columns placed in the lower area of the Column
Breaks section are assigned the sum of
[COLUMN] summarization. If the data type of
the column is text, it is assigned the last of
[COLUMN] summarization.
To change the tabulation function summarization:
-
In the lower area of the Column Breaks section, click
the tabulation function field containing the summarization that you want to
change.
A tabulation function field is outlined in red in the image below.
The Trillion-Row Spreadsheet displays the
Tabulation
Function menu.
-
Select the type of summarization you want to perform.
For information about the types of summarizations available, see
Types of summarizations.
Note: If the type of summarization you
are performing requires a second column (a reference column), the available
columns are displayed after selecting the summarization. Select the
reference column from the Tabulation Function
menu.
The Trillion-Row Spreadsheet updates the tabulation function field with
the selected summarization.