You can group transactions in the Aeon Desktop Client to arrange them in a viewing order that works for you. Grouping allows you to sort data by columns other than the default column as well as by values of one or more of the columns. Multiple columns can be grouped to break the data down further. Groups are displayed in a tree interface and can be expanded or collapsed. Right-click on the column headers to bring up the grouping commands. You can also sort the information in the column in ascending or descending order, and filter the information shown in the column.
Arrange Grid By Column
To simply rearrange the order of one or more of the columns, click and drag the columns to the order you choose.
The Group By Box Option
The Group By Box option is a visual representation of what fields are being grouped and in what order. In the image below, the transactions in the grid have been grouped by Transaction Status and then again by Document Type.
- To display the group by box option, right-click on the grid and click Show Group By Box.
- Above the grid, a small space appears that says, Drag a column header here to group by that column.
- To add a column to the grouping, drag the column header into the group by box space.
- If there are multiple columns being grouped, you can order which grouping occurs first by dragging column headers above or below the other column headers in the space.
- The result of your grouping is displayed in the grid in a tree interface.
Ungrouping a Group by Box
- To ungroup a column, drag it out of the group by box space and place it back with the other column headers in the appropriate position.
- A small black rectangle will display to indicate where the column will be placed on the grid.
- Remove a column from the grid by dragging the column header down into the grid. You will see a large X and the column will be removed from the grid.
Expanding, Collapsing, and Clearing a Group by Box
- To expand or collapse the box tree, clear the group by box space and start over, or just hide the Group by Box space, right-click in the box space to see the Expand/Collapse/Clear/Hide Group by Box commands.
- Choose the function you want to use.
The Group By Column Option
In addition to the group by box, you can quickly group by column.
- Right-click on the column header you want to group by and choose Group By This Column.
- The grouping is displayed in the grid in a tree interface.
- The group by box will not automatically display when grouping by a column unless you have already chosen to display it using the Show Group By Box option from the menu.