Docs  /  Excel Report Builder  /  Edit Evaluations  /  PivotTable Sheets

 PivotTable

2024/10/24 • 2 min. to read

In this topic

• Fields
• Data Sheet Fields
• Actions
• PivotTable Fields
• Actions
• See also

The PivotTable page is used to set up the general settings of the PivotTable and the fields of the PivotTable. In order for a PivotTable to be created, it must first be specified for which Data Sheet it is to be created. After that, the fields for the PivotTable can be selected. The general settings of the PivotTable Sheet can be set up via the Sheet Settings action. For more information, see Edit Evaluations, PivotTable Sheets, Sheet Settings.

Data Sheet Fields

Once a Data Sheet is specified, the tables and fields from the Data Sheet are displayed here.

Actions

• Data Sheet Fields can be added to the PivotTable via the Add action or by clicking on the field.

  Note

  • Text lines and internal fields cannot be added to a PivotTable and are therefore not displayed.
  • Fields from a parallel tree structure cannot be added to a PivotTable directly but only indirectly via the first tree structure. Parallel tree structures are displayed red + italic for guidance.

PivotTable Fields

The fields of the PivotTable are displayed here.

Actions

• Via the Settings action or by clicking on the field, the settings for the field can be displayed or set up. For more information, see Edit Evaluations, PivotTable Sheets, Field Settings.
• The Move to action moves the field to another area.
• The position or the order of the fields can be changed with Up and Down.

See also

• Edit Evaluations, PivotTable Sheets, Sheet Settings
• Edit Evaluations, PivotTable Sheets, Field Settings