Reordering columns and rows

Change how a table view is sorted temporarily to focus on specific column details or in a more permanent way if it should always appear sorted in this manner. You can also reposition columns for a more logical organization or to emphasize columns of interest.

About this task

You can set the sort order in three ways. Take one of the following steps

• Reorder the table view columns or chart view data series by clicking the column heading and dragging to the new position:
  • If you open a workspace and drag the column heading in a workspace table view, the change is temporary unless you save the workspace. You can also right-click a column heading and click Lock this Column to fix the column and any columns to the left of it so that they do not move off the viewable area of the pane when you scroll horizontally.
  • If you click Edit properties in the table- or chart view title bar and drag a column heading in the Filters tab, the change is temporary unless you save the workspace.
  • If you click Query Editor and drag a column heading in the Specification tab, the changes are saved with the query and applied to any views that use that query. Column reordering must be done in a custom query because predefined queries are not editable.
• Sort the row data in a table view:
  • Click Query Editor, open a custom query, click Advanced, and select a Sort By attribute from the list.
  • In a table view, click a column heading to sort all rows by that column in ascending order, descending order, and back to the original order the third time you click. You can save the view's sort order with the workspace.