Moving Pivot Table Elements

To move a column to a new location in the Content pane, select the column in the Content pane and drag it to a new position.

To remove Request items from the data layout or columns from the Content pane, select the element and select Pivot, then Remove Selected Iten.

Note:

When you delete a Request item from the data layout or a column from the Content pane, you cannot use the Undo feature to reinsert the column or Request item.

To move a pivot element item using the data layout, select the item name in the data layout pane, drag the item to a new position or to another data layout pane.

The display updates to reflect the repositioning or reassignment of the item.

Note:

To move items between Column Labels or Row Labels panes and the Fact pane (or vice versa), you must first remove them from the data layout, and then add them again to the chosen pane.