Move Pivot Table Layers

Rearrange pivot table layers to better analyze data.

  1. Hover over a heading, until the layer's name appears.
    Pivot table with Move cursor over the border of a heading
  2. Click and drag the layer to a new location.
    Pivot table layer dragged to top row.

    When you release the cursor, the table is reorganized and the aggregate counts in the data cells are re-calculated.