2011

Combine Record Mode Displays numeric data in the selected column as
separate values or collapses identical property rows into one row and displays
the sum of all the numeric data in the selected column. This option is available
when the Combine Identical Rows is checked and the selected column contains
numerical data.
Show Count Column Displays a Count column that lists the quantity of each
property.
Show Name Column Displays a Name column that displays the name of
each property.
Insert Totals Footer Displays a flyout menu with options for Sum, Max, Min,
and Average. Creates a footer row for the selected column that is placed below
all the data rows and displays values based on the selected arithmetic function.
This option is available only for columns that have a numeric data type.
Sum Displays a sum of all the values in the selected column in a footer row.
Max Displays the maximum value in the selected column in a footer row.
Min Displays the minimum value in the selected column in a footer row.
Average Displays the average value in the selected column in a footer row.
Remove Totals Footer Removes the Totals footer. This option is available
when a footer row exists.
Filter Options Displays the
Filter Column dialog box on page 441, where you
can specify filter conditions for the selected column.
Reset Filter Restores the default filter for the selected column.
Reset All Filters Restores default filters for all columns that have filters.
Copy to Clipboard Copies all the data cells, including column names, to the
Clipboard.
Choose Output
Specifies the type of output to which the data is extracted.
422 | Chapter 5 D Commands