Overview in WPF Pivot Grid

The pivot schema designer can be supported in the pivot grid, so that it can be presented like an ExcelPivotTable. By using the pivot schema designer, you can add, rearrange, or remove fields to show data in the pivot grid exactly the way you want. It contains two sections, consisting of the following items:

  • A field section at the top is used for adding and removing fields from the pivot grid.
  • A layout section at the bottom is used for rearranging and repositioning the fields in the pivot grid.

Fields section

The Fields section consists of a list of fields present in the pivot grid including row, column, and summary elements, which is called as PivotTable Field List. A field will be added to the pivot grid if it is checked, or it will be removed from the pivot grid if it is unchecked. By default, fields will be added to the row label if checked, and added to the column label by simply dragging the field to the column label area. The filtering process is also supported in the pivot table field list. Filter pop-up will be opened while clicking the expander icon in the right-corner of each pivot table field list items.

FieldsSection

Layout section

The layout section is used to rearrange and reposition the fields in a pivot grid. It has the following areas:

  • Report filter
  • Column label
  • Row label
  • Values

Layout section

Report filter

The report filter is used to filter the entire report based on the selected item in the report filter. The report filter pop-up window can be launched by clicking the expander icon available in the right-corner of each filter item.

Filter Popup window

Column label

The column label is used to display fields as columns at the top of a report. A column at the lower position is nested within another column positioned immediately above it in the pivot grid.

Row label

Row label is used to display fields as rows at the top of a report. A row at the lower position is nested within another row positioned immediately above it in the pivot grid.

Values

The values section is used to display the summary fields of the pivot grid.