This article describes the appearance and behavior of the PivotGrid configurator.
The Pivot Grid Configurator contains the following sections:
Fields display in a TreeView with checkboxes. Here is how they work:
- The TreeView items and their checkbox state are populated automatically, based on the PivotGrid data and initial configuration.
- Users can check and uncheck TreeView items, which will add or remove the respective Field in the Columns or Rows sections.
- If a field is defined in a
<PivotGridColumn>tag in the Pivot Grid, then users cannot use that field in another Configurator section.
- If a field is not defined anywhere in the PivotGrid declaration, then checking a TreeView checkbox will add it as a column field. Then, the user can drag it to another section.
The Columns section of the Configurator shows all fields that are currently used as column headers.
The Rows section shows the fields that are used as row headers.
The Row and Column fields support sorting and filtering of the field values. User should click the three dots in each chip to open a context menu with these options.
The Values section of the Configurator shows all fields that are currently used as measures (dimensions).
The bottom section of the Configurator renders Apply and Cancel buttons. End users should click them after adding or removing fields to the Columns, Rows and Values sections.
The following user actions do not require users to click on Apply:
- Reordering already added fields via dragging
Refer to the example of a Pivot Grid using an XMLA Data Provider Type.