Action: Cross Tabulate

These are the input types for the various parameters associated with a Cross Tabulate action within a Quick Query.

Parameter: Row group x

Input Type Description
Dropdown,Required The user is required to choose a column via a drop-down selection box.
Dropdown,Opt Out The user may choose a column via a drop-down selection box. The selection box is initially shown with a column selected, but the user may clear it. If the user clears it (i.e., chooses no column), the tabulation is done using the remaining grouping columns, if any.
Dropdown,Opt In The user may choose a column via a drop-down selection box. The selection box is initially shown with no column selected. If the user leaves it blank (i.e., chooses no column), the tabulation is done using the remaining grouping columns, if any.

Parameter: Column group x

Input Type Description
Dropdown,Required The user is required to choose a column via a drop-down selection box.
Dropdown,Opt Out The user may choose a column via a drop-down selection box. The selection box is initially shown with a column selected, but the user may clear it. If the user clears it (i.e., chooses no column), the tabulation is done using the remaining grouping columns, if any. If no column-group columns are chosen, a straight tabulation is done.
Dropdown,Opt In The user may choose a column via a drop-down selection box. The selection box is initially shown with no column selected. If the user leaves it blank (i.e., chooses no column), the tabulation is done using the remaining grouping columns, if any. If no column-group columns are chosen, a straight tabulation is done.

Parameter: Column for result x

Input Type Description
Dropdown,Required The user is required to choose a column via a drop-down selection box.
Dropdown,Opt Out The user may choose a column via a drop-down selection box. The selection box is initially shown with a column selected, but the user may clear it. If the user clears it (i.e., chooses no column), the tabulation has one fewer result.
Dropdown,Opt In The user may choose a column via a drop-down selection box. The selection box is initially shown with no column selected. If the user leaves it blank (i.e., chooses no column), the tabulation has one fewer result.

Parameter: Summary for result x

Input Type Description
Dropdown,Required The user is required to choose a summarization method via a drop-down selection box.
Dropdown,Opt Out The user may choose a summarization method via a drop-down selection box. The selection box is initially shown with a method selected, but the user may clear it. If the user clears it (i.e., chooses no method), the tabulation has one fewer result.
Dropdown,Opt In The user may choose a summarization method via a drop-down selection box. The selection box is initially shown with no method selected. If the user leaves it blank (i.e., chooses no method), the tabulation has one fewer result.

Parameter: Weight for result x

Input Type Description
Dropdown,Required The user is required to choose a column via a drop-down selection box.
Dropdown,Opt Out The user may choose a column via a drop-down selection box. The selection box is initially shown with a column selected, but the user may clear it. If the user clears it (i.e., chooses no column), equal weights are assumed.
Dropdown,Opt In The user may choose a column via a drop-down selection box. The selection box is initially shown with no column selected. If the user leaves it blank (i.e., chooses no column), equal weights are assumed.