PivotGridFieldBase.SummaryFilter Property

Gets summary filtering settings.

Namespace : DevExpress.XtraPivotGrid

Assembly : DevExpress.PivotGrid.v25.2.Core.dll

NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

• C#
• VB.NET

[Browsable(false)]
public PivotSummaryFilter SummaryFilter { get; }

<Browsable(False)>
Public ReadOnly Property SummaryFilter As PivotSummaryFilter

Property Value

A PivotSummaryFilter object that encapsulates summary filtering settings.

|

Remarks

PivotGridControl allows you to filter its data by summary values. Use the SummaryFilter property to configure filtering by summary values calculated against the current data field.

Use the returned PivotSummaryFilter object to access summary filtering settings.

Note

You cannot use the CalculationBindingBase descendants to apply summary filter when Pivot Grid operates with Optimized calculation engine.

To enable summary filtering, specify the range of summary values that should be included into the pivot grid. Additionally, provide column and row fields that identify the target data detail level if you wish to apply filtering to Total or Grand Total values.

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.

For more information, see Filter by Summaries.

See Also

PivotGridFieldBase Class

PivotGridFieldBase Members

DevExpress.XtraPivotGrid Namespace