Editing query result set columns

You use the Result set pane of the Display editor to modify the columns of a result set.

1. Navigate to the query that has the result set that you want to edit and open it in the Visual Query editor.
2. Click the Display tab.
   The Display editor opens.
3. To roll up a column into the top group, right-click the column and select Top Group from the menu.
4. To roll up a column into the side group, right-click the column and select Side Group from the menu.
5. To add aggregation to a column, right-click the column and select an aggregation type from the menu.
   Available aggregations are:

   • Average
   • Count
   • Cumulative Percentage of Group
   • Cumulative Percentage of Total
   • Cumulative Sum
   • First
   • Last
   • Maximum
   • Minimum
   • Percentage of Group
   • Percentage of Total
   • Standard Deviation
   • Sum
6. To remove aggregation from a column, right-click the column and select No Aggregation from the menu.
7. To add a count column to the layout structure of the selected display mode, right-click the (count) column in the Columns with aggregates node and select To Layout structure from the menu.