PivotFieldSortOptions.AutoSortField Property

Gets the index of the data field used by the sort criteria applied to the pivot field.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

int AutoSortField { get; }

VB.NET

ReadOnly Property AutoSortField As Integer

Property Value

Type	Description
Int32	An integer value that is the zero-based index of the data field in the PivotDataFieldCollection.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AutoSortField
PivotField	.Sort .AutoSortField

Remarks

The AutoSortField property returns -1, if the specified pivot field is not sorted by values in a data field.

To sort a row or column field in a pivot table based on values in a data field, use the PivotField.SortItems method.