Adding and Rearranging Columns in Views

Using the view editor and the Layout pane, you can easily modify and change the order of columns in the following ways:

• Drag and drop columns in tables and pivot tables to the desired positions in the editor using the handles and drop targets. For example, if you have two columns in the Rows section of a pivot table, reverse the order of the columns by dragging and dropping the first column after the second one. In a table, you can drag and drop columns, but you cannot stack columns, as you can in a pivot table.

  You can also drag and drop columns in this way in the Compound Layout.

• Drag and drop columns in the Layout pane. A target is active and ready for the "drop" when it appears highlighted. When you hover the mouse pointer over a column in the Layout pane, the cursor state changes from the pointer to a move cursor when you can "grab" the column and move it over a drop target. For example, you can easily move a column in a pivot table from the Rows drop target to the Sections target to create a unique pivot table for each value in the column.

  For details of dragging and dropping columns in the Layout pane of the trellis editor, see "Drop Target Guidelines for Trellises".

• Add a column to a graph or gauge. To do so, drag the column from the Subject Areas tab to the appropriate location in the view editor or to a drop target in the Layout pane.

• Remove columns in the Layout pane. For example, you can easily remove a column in a view by selecting Remove Column from the More Options button. Removing columns differs from excluding columns, which is described in "Drop Targets".

This list provides only a partial summary of where dragging and dropping can occur. You can drag and drop columns and catalog objects whenever you see the Subject Areas pane and Catalog pane. You can also drag and drop items in views on dashboards. See "Columns in the Excluded Drop Target" for more information.