How can we help you?

Fields from the Available fields section can be added to sections manually or automatically. If fields are added automatically, they are allocated between the Rows and Values areas according to the data type:

If a field contains text values, it will be moved to the Rows section.

If a field contains numerical values, it will be moved to the Values section.

To automatically distribute fields between the Rows and Values sections, follow these steps for each of these fields:

1.In the Available fields section, hover the cursor over the title of the field which needs to be moved to the Rows or Values sections.

2.Click side_panel_pivot_table_add Add.

pivot_table_add_field_auto

To add fields to the sections manually, drag and drop them into the appropriate sections while holding down the left mouse button, or do the following for each field:

1.In the Available fields area, hover the cursor over the field that you want to add to the area.

2.Click side_panel_pivot_table_more More.

3.In the menu that appears, select the section in which you want to add the field.

pivot_table_add_field_manual

Calculated fields created in a third-party application can only be moved to the Values section.
Was this helpful?
Yes
No
Next
Change the field order in a section