Select a column, then select Results--> Grouping and Aggregation--> Side group with summaries to:
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.
Also, you can drill-down (+) to view detailed data or roll up (-) to view summary data.
Things to note in the example below:
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 | |