Skip to main content
All docs
V25.1
  • Row

    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.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 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:

    // Access a pivot table.
    PivotTable pivotTable = worksheet.PivotTables[0];
    
    // Move the "Category" row field to the first position.
    pivotTable.RowFields["Category"].Position = 0;
    

    Rearrange pivot fields

    See Also