Reordering Fileds in Pivot Table

Reordering fields is the key point in finding the best table layout to understand data dependencies, make the conclusions, and use them to your benefit.

A pivot table is the very place where you can change the location of any field with a single drag of a mouse. Drag-and-drop a field from one area to another to rearrange their data.

Reordering Fields

You can easily swap row and column fields to display row field values in columns and column field values in rows. Compare the two screenshots.

Reordering Fields

If there are two or more fields in one section, you can use Order options from the right-click to reorder the fields within the area.