Adding Summaries to Query Results

 

Follow the steps below to add (group) summaries to query results:

1. From the Menu Bar, Select Format \ Break Groups.
2. In the Groups tab, select the field(s) on which you would like to group your data.
3. Then click the Group>>>> button.
4. When all of your groups have been designated, click Apply, then OK.
5. Click the Summaries tab.
6. Highlight a Column and choose the Summary Operation(Totals, Count, Maximum and Minimum)you want in your results.

For details on other functions that you can set with break groups refer to the Query online help.

Note: You can add a break group, either before or after you run your query:

IBM Ref#: 1475521