User's Guide Tables Modify a Pivot Table Move Pivot Table Layers Move Pivot Table Layers Rearrange pivot table layers to better analyze data. Hover over a heading, until the layer's name appears. Click and drag the layer to a new location. When you release the cursor, the table is reorganized and the aggregate counts in the data cells are re-calculated.