A.3.6 Using Group By

Group sets of results by one or more columns with Group By, then perform mathematical computations against the columns.

Once defined, you can switch between the Group By and Report using view icons on the Search bar.

To create the group by, follow these steps:

1. Click Actions menu and select Group By. The Group By page is displayed.
2. Select / Enter the fields as described in the following table.

   Table A-2 Group By - Fields and Descriptions

   Field	Description
   Group By	Select the column to be grouped from the drop-down list.
   Add Group By Column	Click Add Group By Column to add another column to be grouped.
   Function	Select the Function from the drop-down list.
   Column	Select the column from the drop-down list.
   Label	Enter the label of the column.
   Format Mask	Select the Format Mask from the drop-down list.
   Sum	Move the toggle button to the right to enable the Sum option.
   Add Function	Click Add Function to add another function.

3. Click Apply. The View Group By page is displayed.
   The Search bar now contains View Report and View Group By icons. Click these icons to toggle between report and Group By views.