Perform Advanced Grouping

You can perform more advanced groupings in a list to get the results you want.

For example, you can

  • view the entire grouping structure and make changes to the grouping order
  • group a data item that appears in a query but not in the layout
  • specify a list of properties for a group

You can also perform advanced sorting.

Procedure

  1. Click a column in the list.
  2. Click the Show properties icon Show properties icon, click the Select ancestor icon Select ancestor icon in the title bar of the Properties pane, and click List.
    Tip: You can also click the container selector (three orange dots) of the list to select it.
  3. In the Properties pane, double-click the Grouping & Sorting property.
  4. To change the grouping order, in the Groups pane, click the grouped item in the Groups folder and drag it to the grouping hierarchy.
  5. To create a new grouping, in the Data items pane, click the data item and drag it to the Groups folder in the Groups pane.
  6. To specify a list of data items for a group, do the following:
    • Click the group.
      Tip: Click Overall to specify a list of data items for the overall group. The overall group is the grouping of all data into one group. You can specify a list of data items for the overall group to add overall totals to the list.
    • Click the properties button Show properties icon.
    • Select the appropriate check boxes.