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

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.