ACE Analytics Grouping Rows

The Group feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column header, lets you group table rows:

Here's how to use this feature:

1. Select the Grouping Column for the first level of grouping from the list of columns. Depending in the column's data type additional input controls may be displayed. Click Add to group the data and refresh the table. Repeat as desired to create sub-groups.
2. As groups and sub-groups are created, they're added to the Groups list. Use the adjacent Remove and Replace buttons to manage the list.
3. The Exclude Detail Rows checkbox can be used to hide the rows that have been grouped, "collapsing" each group into a single row in the table.
4. The Results Positioning options let you display aggregation results right below the column headers (Top) or at the bottom of the table rows (Bottom).

Click the Gear icon to hide the configuration area.