Step 2. Group your Results
A group is a set of records that are related to each other in some way. In the files supplied for this tutorial, the records are related by country and warehouse.
1.Close the
window and open the dialog using the button on the toolbar.2.In the list of
select the Sales country is equal to NZ and delete it.
3.Press the
button to close the dialog.4.Run the Query to produce results for all Sales Countrys, except US.
5. Display the pop-up menu of available commands by clicking on the right mouse button.
6. Select the
command to open the dialog box. Alternatively, you could select it using the icon on the toolbar.
All the fields defined for the query are displayed in the
list in the dialog box.7. You are going to group the data according to Sales Country.
a. To do this, double-click on the Sales Country in
or alternatively, select the Sales Country and click on the button. You will notice that Sales Country is immediately displayed in the list.8. Select
option, to have the summary totals calculated for each group.
9.When done, press the
button.The Results window will now show the new results.
10.Scroll through the Results window. You will see that there are additional rows for each Sales Country. This is the result of applying the grouping conditions.
Notice that at the end of the results you still have the totals which apply to all the records in the query.