Step 1 Add Summaries

LANSA Client

Step 1. Add Summaries

Now to define summaries for your results. A summary can be the result of an evaluation, a summation or a calculation.

1.  First, with your mouse pointer somewhere in the Results window, right click on your mouse to open the pop-up context menu.

2.  Select the Summary Options command to open the Summary Options dialog box. In this dialog box, you can define the summaries you require for the numeric fields in your query. Alternatively, you can open the Summary Options using this icon on the toolbar.

3.  Request totals for January through to March by clicking the Average and Sum options for each of those months. A tick will be inserted when each box is selected.

4.  Request a Count of the records by clicking on the Count option for the Sales Warehouse.

5.  When done, press the OK button.

     You are returned to the Results window. At the bottom of this window you will see a new row for each summary you have requested.

6.  Go to Step 2. Group your Results.