All docs
V20.2
20.2
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotItem.Position Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

int Position { get; set; }
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:

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