Field Location Areas
- 2 minutes to read
Pivot grid fields can be positioned within one of four areas within the ExpressPivotGrid control: the data, column, row, and filter header areas. A user can move fields between the areas using drag-and-drop operations to fine-tune the resulting report.
The purpose of these areas is described in the following table.
| Area | Description |
|---|---|
| Data Header | This area contains data fields - the fields against which summaries are calculated. The summary results are displayed within the data area. |
| Column Header | This area displays column fields. The values of these fields are listed along the control’s top edge and these represent column headers. |
| Row Header | This area displays row fields. The values of these fields are listed down the control’s left edge and these represent row headers. |
| Filter Header | This area displays filter fields which allow end-users to apply filtering to the entire ExpressPivotGrid control to display data for the predefined values. |
The visibility of these areas is controlled by the pivot grid’s OptionsView.DataFields, OptionsView.ColumnFields, OptionsView.RowFields and OptionsView.FilterFields options.
A field’s location is specified by its Area property. Its AreaIndex property specifies the field’s position (order) amongst the other fields that are displayed within the same area.
By default, fields can be located within all the available areas. You can use the AllowedAreas property to explicitly specify in which areas the field can be placed.