Editing display mode layout structures

You use the Layout structure pane of the Display editor to edit the layout structure of individual display modes.

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. Select the display mode that you want to edit.
   The layout structure of the selected display mode opens in the Layout structure pane.
4. To roll up a column into the top group or side group, click and drag the column to the Top Groups or Side Groups nodes.
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 pop-up menu.
7. To remove a column from the layout structure, right-click the column and select Remove from the pop-up menu.
8. To change the order of the columns, click a drag the columns to place them in the order that you want them to appear in the result set.
9. If you are editing the layout structure of a chart, you can click and drag columns to move them to and from the Category Axis and Values nodes.