The results grid displays data for the selected columns, for Loads located using the criteria as described in the Filters topic. You can change the columns displayed, their relative positions and widths as described in the Layouts topic.

Say we want to see the total sale value of all loads to Customers for a period. In the screen below we have filtered Loads by the required date range, to a Customer (From the first Customer To the last Customer), excluding loads marked as Storage Only.

We scroll right to display the Customer Name column, right-click the column heading and select Group By This Column from the popup menu:

The results grid is immediately grouped and sorted by Customer Name:

To report on subtotals for the sale values of the displayed loads, scroll if necessary to display the Customer Load Total column. Right-click the column heading and select Show totals for this column from the popup menu:

The total of the sale values for each customer for the displayed loads is immediately calculated and displayed in the group headings:

You can have multiple grouping columns and multiple subtotal columns. To remove a subtotal, right-click the column heading for that column and select Remove totals for this column from the popup menu. To remove grouping for a single column right-click the column heading and select Don't Group By This Column from the popup menu, or to remove all groupings select Remove Grouping. Removing a grouping also removes subtotals for that column, if activated. Removing all groupings also removes all subtotals, if activated.

Back: ←Filters