Define the structure of the pivot table

By default, a pivot table does not contain data because its structure is not defined. To define the structure, use the Constructor tab in the pivot table settings pane.

The Constructor tab includes the following sections:

–Available fields: This section includes the list of all selected columns of the initial table (the fields). To set the structure of the pivot table, add the fields from the Available fields section to the Rows, Columns, Values, and Filters sections.

–Rows: Add the fields which will become the headings of the pivot table rows to this section.

–Columns: Add the fields which will become the headings of the pivot table columns to this section.

–Values: Add the fields whose values will be used for calculations to this section.

–Filters: If necessary, add the fields that will be used to filter data in the pivot table to this section. Filters allow you to set the level of detail of the data and change the way the table looks.