Skip to main content
.NET Framework 4.5.2+

PivotField.SortType Property

Gets or sets the type of sort to apply to the PivotTable field.

Namespace: DevExpress.Spreadsheet

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


PivotFieldSortType SortType { get; set; }

Property Value

Type Description

One of the PivotFieldSortType enumeration values specifying the sort order.


Use the SortType property to sort item labels in a specific row, column or page field in a PivotTable report in ascending or descending order. Sort options are available using the PivotField.Sort property.

The following example sorts items of the “Product” field in ascending order.

View Example

Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Access the pivot field by its name in the collection.
PivotField field = pivotTable.Fields["Product"];
// Sort items in the "Product" field. 
field.SortType = PivotFieldSortType.Ascending;

You can also sort a row or column field based on values in a data field. To do this, use the PivotField.SortItems method.

The following code snippets (auto-collected from DevExpress Examples) contain references to the SortType property.


The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also