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.