Setting Sorting and Subtotals 

Use

You have created the query G5 as shown in the section Define Multiple Line Basic Lists .

1. Copy query G5 and give the copy the name G6.
2. Highlight the G6 query and click on the Change function.
3. Adjust the title and the note.
4. Expand the field selection using fields from the Bookings field group.

You can see below which fields are to be included in the display.

5. Click on Basic List.

In the Basic List Line Structure screen, extend the definition of the basic list. Specify which field you want to sum. Also mark the Total checkbox for the Booking Price in Foreign Currency line.

6. In order to count the number of bookings, select the Payment column for the Occupied Seats field.



7. To display the Control Levels screen, click on Next Screen .

Since you want to display a sub-total and the number of bookings for each flight, the Total and Counter columns are selected for the field Flight date.



On this screen, you cannot determine the field you want to sum or count, but only at which level you want to display a sub-total or number of bookings for the fields you have defined on the Basic List Line Structure screen for summing or counting respectively.

8. Mark the Box checkbox for the Flight date field.



9. To display the Field Display Options screen, click several times on Next Screen .

Set the booking price to appear together with the currency.



10. Use the Test function to test the query.

Options for Line Layout: Totals and Counting