Skip to main content
All docs
V24.1
Row

PivotItem.Position Property

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

int Position { get; set; }

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:

// 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;

Rearrange items in a pivot field

See Also