PivotFieldReferenceBase.Position Property

Returns or specifies the field position in the collection that corresponds to the PivotTable area where this field is located.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

int Position { get; set; }

VB.NET

Property Position As Integer

Property Value

Type	Description
Int32	A zero-based index of the field in the collection.

Remarks

Use the Position property to rearrange fields in a specific area of the PivotTable report.

The following example moves the Category field to the first position in the row axis area:

C#

// Access a pivot table.
PivotTable pivotTable = worksheet.PivotTables[0];

// Move the "Category" row field to the first position.
pivotTable.RowFields["Category"].Position = 0;

VB.NET

' Access a pivot table.
Dim pivotTable As PivotTable = worksheet.PivotTables(0)

' Move the "Category" row field to the first position.
pivotTable.RowFields("Category").Position = 0