Sets grouping options for the selected item in the left pane of the Excel window. The grouping options define the properties that group the input data into composite rows when one row of output is based on multiple rows of input, such as in MTO reports.
Many of the delivered reports use grouping definition. The graphics below show the properties identified by the delivered Piping Pipe Total Length Sorted by NPD report.
Use Grouping
Enables the controls on this tab.
Grouping By
Attributes
Lists the attributes available for grouping. You use the single arrow buttons to move individually selected attributes in the direction of the arrow, or use the double arrow buttons to move all attributes in the direction of the arrow.
Attributes used for grouping
Lists the columns you want to use for grouping. You can move items back and forth between the two main boxes on this dialog box by using the arrow keys in the middle of the dialog box.
Item Tag Number
Style
Specifies the style applied to the item tag number. Values are Numeric (default setting) and Alphabetic.
Base value
Specifies the counting starting point for the item tag number. The default is 1 for Numeric and A for Alphabetic. If the style is Alphabetic, only the letter values A through Z will be accepted, and you are limited to six letters in length. Lowercase characters are changed to uppercase automatically.
Step
Identifies the counting increment value. The default is 1. This field is numeric only.
Is continued?
If checked, specifies that the numbering starting point continues from the previous item tag number in the report layout. This checkbox overrides the Base value setting. Default is unchecked.
Column name
Identifies the name of the item column in the spreadsheet.
Is Locked?
Specifies whether the cell is locked or not. You can lock cells to prevent changes. For more information about locking cells and protecting data, see the Microsoft Excel Help.
Quantities
Delete
Removes the selected quantity attribute row from the Quantities table.
Quantity attribute
Provides a dropdown list of all report attributes. You select an attribute for which you want to include totals and sum totals in the specified total column.
Quantity total column name
Specifies the name of the quantity column for the selected attribute.
Is Locked?
Specifies whether the cell is locked or not. You can lock cells to prevent changes. For more information about locking cells and protecting data, see the Microsoft Excel Help.
