Change the field order in a section

Move a field from one section to another

You can manually move fields from one section to another, similar to adding fields from the Available fields section to the other section in the Constructor.

Change the field order in a section

In any section other than the Available fields section, you can change the order of the fields in the list. The position of the field in the list determines the position of the corresponding field in the pivot table. The arrangement of fields in the Columns and Rows areas also determines the parent-child hierarchy of fields in the table: a field lower in the list is a child of the parent field above it. The hierarchy determines how fields are grouped in the table.

To change the position of a field relative to other fields in the list, drag it to the desired location in the list while holding down the left mouse button, or do the following:

1.Hover the mouse cursor on the field and click  More.

2.In the drop-down menu, select the desired command:

•Move to beginning: Move the field to the beginning of the list.

•Move up: Swap the selected field and the previous field.

•Move down: Swap the selected filed and the next field.

•Move to end: Move the field to the end of the list.

The drop-down menu commands depend on the position of the selected field in the list.