PivotFieldSortOptions.ItemReferences Property

Provides access to the collection of PivotItemReference objects used by the sorting criteria applied to the pivot field.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

PivotItemReferenceCollection ItemReferences { get; }

VB.NET

ReadOnly Property ItemReferences As PivotItemReferenceCollection

Property Value

Type	Description
DevExpress.Spreadsheet.PivotItemReferenceCollection	A collection of the PivotItemReference objects.

Property Paths

You can access this nested property as listed below:

Object Type	Path to ItemReferences
PivotField	.Sort.ItemReferences

Remarks

The ItemReferences property returns an empty collection if the specified field is not sorted by values in the data area.

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