Skip to main content

PivotGridOptionsDataField.AreaIndex Property

Gets or sets the position of the data field headers.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public int AreaIndex { get; set; }

Property Value

Type Default Description
Int32 -1

An integer which specifies the position of the data field headers within the hierarchy of field values.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to AreaIndex
WinForms Controls PivotGridControl
.OptionsDataField .AreaIndex
Reporting XRPivotGrid
.OptionsDataField .AreaIndex


Data field headers are displayed when the XtraPivotGrid control contains two or more data fields. By default, the AreaIndex property is set to -1, so the data field headers are displayed immediately above the Data Area when they are positioned within the column area (or immediately to the left of the Data Area when positioned within the row area):


Setting the AreaIndex property to 0 displays data field headers above the field values of the first column field:


If the AreaIndex property is set to 1 the data field headers will be displayed under the field values of the first column field, as in the image below:


The following code snippets (auto-collected from DevExpress Examples) contain references to the AreaIndex property.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also