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.
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 |