In list views you can group data by any field:

 

  1. In List View right-click the column heading for the field that you want to use for grouping the data, then choose Add Leading Group by <field name> or Add Trailing Group by <field name>.

    For example, If you want to display the summary for your parts in stock and add a summary row at the end of the records for each part, choose Add Trailing Group by Part_Quantity_In_Stock. If you want to add the summary row before the records for each part, choose Add Leading Group by Part_Quantity_In_Stock.

    Adding a leading/trailing group automatically sorts the records by the field that you used for grouping the data. For example, the parts will be listed in alphabetical order.
Top of Page