TcxPivotGridSortBySummaryInfo Class
Contains the settings used to sort the values of a column field or row field by the grand total summary values calculated for another field.
Declaration
TcxPivotGridSortBySummaryInfo = class(
TPersistent
)Remarks
By default the field values of a column field or row field are arranged in alphabetical order (for text data) or in order of magnitude (for numeric and date-time data) as specified by the field’s SortOrder property’s value. In certain cases it may be necessary to sort the field values according to the grand total summary values which are calculated against another field (for instance, against a particular data field). This functionality is called “Sorting by Summary” and provided by the field’s SortBySummaryInfo property which represents an instance of the TcxPivotGridSortBySummaryInfo class.
Using the SortBySummaryInfo.Field property you can specify the field against which a specific summary will be calculated and whose grand total summary values will determine the order in which the field values of the column/row field will be arranged. You can also specify the type of the summary function which will be used to calculate against the field (via the SortBySummaryInfo.SummaryType property).