Differences

This shows you the differences between two versions of the page.

--- gt3:loads:search:grid [03/06/2021 02:05]
Ian Davidson [Grouping]
+++ gt3:loads:search:grid [03/06/2021 02:36] (current)
Ian Davidson [Adding Subtotals For Numeric Columns]
@@ Line 11: / Line 11: @@
 {{ :gt3:loads:search:search-21.png?nolink |}}
-You can also sort by multiple columns at once by holding down the **Shift** or **Ctrl** key and left-clicking another column heading (or right-clicking it and selecting an option from the popup menu). WHen you sort by multiple columns you get arrows in both columns, together with a number indicating which column is sorted first and so on:
+You can also sort by multiple columns at once by holding down the **Shift** or **Ctrl** key and left-clicking another column heading (or right-clicking it and selecting an option from the popup menu). When you sort by multiple columns you get arrows in both columns, together with a number indicating which column is sorted first and so on:
 {{ :gt3:loads:search:search-22.png?nolink |}}
@@ Line 23: / Line 23: @@
 {{ :gt3:loads:search:search-16.png?nolink |}}
-We scroll right to display the //Customer Name// column, right-click the column heading and select **Group By This Column** from the popup menu:
+We scroll horizontally if necessary to display the //Customer Name// column, right-click the column heading and select **Group By This Column** from the popup menu:
 {{ :gt3:loads:search:search-17.png?nolink |}}
-The results grid is immediately grouped and sorted by Customer Name:
+The results grid is immediately sorted and grouped by Customer Name:
 {{ :gt3:loads:search:search-18.png?nolink |}}
@@ Line 36: / Line 36: @@
 =====Adding Subtotals For Numeric Columns=====
+You can show subtotals for any column that contains numeric values, and you can have multiple subtotal columns. For example, to report on subtotals for the sale values of the displayed loads, scroll horizontally 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:
+{{ :gt3:loads:search:search-19.png?nolink |}}
+The total of the sale values for each customer for the displayed loads is immediately calculated and displayed in the group headings:
+{{ :gt3:loads:search:search-20.png?nolink |}}
+To remove a subtotal, right-click the column heading for that column and select **Remove totals for this column** from the popup menu. Removing a grouping also removes subtotals for that column, if activated. Removing all groupings also removes all subtotals, if activated.
+=====Opening a Load=====
+You can open a specific load from the results grid by double-clicking on it, or selecting it and clicking the **Open Load** button.
 =====Printing or Exporting the Results=====
+Display or print a summary report of the displayed loads by clicking the **Print Summary** button.
+If you have Microsoft® Excel® installed, you can also click the **Export to Excel** button to create a new spreadsheet containing all the data currently populating the results grid, exactly as shown (ie including any grouping and subtotals that have been configured). This provides you the opportunity to customise the results with other calculations and/or produce a report to your own design.
 {{:gt3:loads:search:blank.png?nolink&10|}}
@@ Line 45: / Line 66: @@
 {{:gt3:loads:search:blank.png?nolink&5|}}
-Back: <-[[gt3:loads:search:filters|]]
+[[gt3:loads:search|]] · Back: <-[[gt3:loads:search:filters|]]