DB2 graphic QMF Version 8

Top group with summaries

Select a column, then select Results--> Grouping and Aggregation--> Top group with summaries to:

Data in the query results can be grouped by columns on the vertical axis. Related values by columns can be grouped on the horizontal axis, which is known as pivot or ACROSS functionality. You can define multiple levels of grouping on both axes. Grouping can be performed by drag-and-drop operations on the columns in the query results, within the layout designer, or within the query results explorer.

For example, select the Top group with summaries option, then specify to group data by EDLEVEL (Education Level). The query results will be reformatted so that the EDLEVEL column spans the other columns in the result set. A summary line for each row in the query results is added in the All values column.

Table 30. Top group with summaries option
05 11 All values
TEMPID NAME ADDRESS TEMPID NAME ADDRESS TEMPID NAME ADDRESS
125 FOX BOSTON 125 FOX BOSTON
460 IDE EL PASO 460 IDE EL PASO
475 TILL SEQUIM 475 TILL SEQUIM


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004