Skip to main content
A newer version of this page is available. .

PivotSummaryFilter Class

Contains summary filter settings.

Namespace: DevExpress.XtraPivotGrid

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


public class PivotSummaryFilter :

The following members accept/return PivotSummaryFilter objects:


A PivotSummaryFilter object can be accessed using the PivotGridFieldBase.SummaryFilter property. This object allows you to configure and apply filtering by summaries.

To configure a summary filter, you should specify the range of summary values that should be included into the pivot grid. If you wish to apply filtering to Total or Grand Total values, additionally provide column and row fields that identify the target data aggregation level.


Use null (Nothing in Visual Basic) values to identify Grand Totals when specifying the target level. Note that if you specify null values for both fields (which identifies the degenerate (Grand Total, Grand Total) level), filtering will be disabled.

To apply summary filtering, use one of the following approaches.

To learn more, see Filtering by Summaries Overview.


See Also