How to Implement the Sorting by Summary Feature

• Jul 30, 2021

This example demonstrates how to sort the values of the ‘Car Name’ row field by summary values calculated for the ‘Payment Amount’ data field. To do this, set the SortBySummaryInfo.Field property of the ‘Car Name’ row field to reference the ‘Payment Amount’ field. As a result, the values will be arranged in the order specified by the grand total summary values. To specify the summary function which will be used to calculate summary values, set the SortBySummaryInfo.SummaryType property of the ‘Car Name’ row field.

The following images show the ExpressPivotGrid control before and after the field values are sorted by the summary values.

Before:

After:

Delphi

PivotGridCarName.SortBySummaryInfo.Field := PivotGridPaymentAmount;

C++

PivotGridCarName->SortBySummaryInfo->Field = PivotGridPaymentAmount;