Change the field order in a section

Moving a field from one section to another

You can move fields from one area to another manually, in the same way you add fields from the Available fields area to other areas of 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 order of fields in the Columns and Rows sections also determines the parent-child hierarchy of fields in the table: a field listed lower in the list is a child of the parent field listed above it. The hierarchy determines how the 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.