How to Control Grouping

Table views are useful when you have lots of data to display because they allow you to sort and group your data. Keep in mind that currently you can only accomplish such grouping in a table view.

Grouping

A Table view can group records under headings.

To create a grouped Table view:

1. Go to the UX > Views tab.
2. Create a Table view.
3. Use GroupBy to select a single column to group your data by.

  Multi-level "Drilldown"

A Table view can group records in a multi-level "drilldown" view.

To create a multi-level "drilldown" Table view:

1. Go to the UX > Views tab.
2. Create a Table view.
3. Use GroupBy to select two or more columns to group your data by. You can group by as many columns as you wish by pressing the + button. Press the X button to remove grouping columns.

Note: If you don't want a grouping header on the final level of grouping, add the _RowNumber column as the final GroupBy column. This makes it easy to select a group from the list.