Skip to main content
All docs
V25.1
  • Row

    PivotItem.Position Property

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

    Namespace: DevExpress.Spreadsheet

    Assembly: DevExpress.Spreadsheet.v25.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