PivotSummaryFilter Class
Contains summary filter settings.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v24.1.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
public class PivotSummaryFilter :
ISummaryFilter,
IXtraSupportShouldSerialize,
IPivotGridSummaryFilterItem
Related API Members
The following members return PivotSummaryFilter objects:
Remarks
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 detail level.
Note
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.
- Call the PivotSummaryFilter.Apply method and pass summary filter settings as its parameters.
Assign summary filter settings to the following properties.
Gets or sets the minimum summary value to be displayed.
Gets or sets the maximum summary value to be displayed.
Gets or sets whether summary filtering should be applied to the last detail level or to the specified one.
Gets or sets a column field used to identify a detail level to which the filtering is applied.
Gets or sets the row field used to identify a detail level to which the filtering is applied.
To avoid unnecessary control updates while customizing these properties, wrap the code in the PivotGridControl.BeginUpdate and PivotGridControl.EndUpdate method calls. To ensure that the PivotGridControl.EndUpdate method is executed even if an exception occurs, you can also wrap calls to the PivotGridControl.BeginUpdate and PivotGridControl.EndUpdate methods in a try…finally statement.
See Filtering by Summaries for more information.