In list views you can group data by any field:
- 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