Move Rows, Columns, and Nesting Levels
In the Enhanced interface, you can drag and drop rows, columns, and nesting levels within your crosstab. You can also reorder measures in your crosstab using drag-and-drop
. This helps you to quickly change the view of your data.
To drag and drop within a crosstab, you must use Internet Explorer as your Web browser.
Steps
- Specify to move or copy a particular level:
- To move a level, click the level selector area of the nested level you want to move.
- To copy a level, press Ctrl and click the level selector area of the nested level you want to copy.
- Choose where you want to drag the level:
- To change the order of levels in an axis, drag the level to a target level area in the axis.
Note: The target level area appears highlighted on the outer edge of an axis.
- To move or copy a level to the other axis, drag the level to a target level area in the other axis.
- To remove the level, drag it outside the crosstab.
- To swap rows or columns, drag the level to the row or column you are swapping with.
- To nest a category quickly, drag the level to the target level area of the level you selected.