Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TcxPivotGridField.SortBySummaryInfo Property

Specifies the options used to sort the values of the current column field and row field by grand total summary values.

#Declaration

Delphi
property SortBySummaryInfo: TcxPivotGridSortBySummaryInfo read; write;

#Property Value

Type
TcxPivotGridSortBySummaryInfo

#Remarks

By default, the values of column fields and row fields are arranged in alphabetical order (for text data) and in order of magnitude (for numeric and date-time data). The SortBySummaryInfo property allows you to arrange these values according to the grand total summary results calculated for another field (for instance, for a data field). Refer to the TcxPivotGridSortBySummaryInfo topic for more information.

To determine whether the values of a field are sorted in this manner, use the SortedBySummary property. To specify the field’s sort order, use the SortOrder property.

The SortBySummaryInfo property along with the TopValueCount property allows you to implement a Top N Values report, which will show only the first records while ignoring the rest.

Note

The SortBySummaryInfo property settings are in effect only in standard data binding modes. In OLAP mode, you can specify how field values are sorted in certain dimensions using a dimension SortMode property.

See Also