Add fields

Fields from the Available fields section can be added to the Rows and Values 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 numeric 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 Add.

To add fields to the Rows and Values 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 section, hover the cursor over the field which needs to be moved to the Rows or Values sections.

2.Click More.

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

Adding fields from the Available fields section to other sections is done manually, similar to adding fields to the Rows and Values sections.