DB2 graphic QMF Version 8

Side group with summaries

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

Note:
The column selected for the side group moves to the left of the query results, and groups like data accordingly.

For example, select the Side group with summaries option, then specify to group data by JOB. The query results will be reformatted so that jobs are listed along the left side of the query results, and data specific to that job is grouped with each job.

Note:
A blank summary line is included as the last row in each group for you to add summary information.

Also, you can drill-down (+) to view detailed data or roll up (-) to view summary data.

Things to note in the example below:

Table 32. Side group with summaries option
1 2 3 4 5 6
JOB ID NAME DEPT YEARS SALARY
(+) MGR 10 SANDERS 20 7 18357.22
(+) SALES 20 PROVENCAL 20 8 18000.06
(-) CLERK 110 NGAN 15 5 12508.20
120 NAUGHTON 38 12954.75
130 MOORE 42 6 10505.90
142 HUME 57 11 14252.75


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