PivotItem.Position Property

Returns or specifies the item position within the field’s item collection.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.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 item in the collection.

Remarks

Use the Position property to rearrange items in a PivotTable field.

The following example moves the last item in the Product field to the second position:

C#

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

// Access items of the "Product" field.
PivotItemCollection fieldItems = pivotTable.Fields["Product"].Items;

// Move the last item to the second position.
fieldItems[fieldItems.Count - 1].Position = 1;

VB.NET

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

' Access items of the "Product" field.
Dim fieldItems As PivotItemCollection = pivotTable.Fields("Product").Items

' Move the last item to the second position.
fieldItems(fieldItems.Count - 1).Position = 1