Moving rows and columns within a dimension element

  1. Activate the pivot table.
  2. In the table itself (not the pivoting trays), click the label for the row or column you want to move.
  3. Drag the label to the new position.