The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

PivotBehaviorOptions.AllowMultipleFieldFilters Property

Gets or sets a value indicating whether fields in the pivot table can have multiple filters applied to them at the same time.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

bool AllowMultipleFieldFilters { get; set; }
Property AllowMultipleFieldFilters As Boolean
bool AllowMultipleFieldFilters { get; set; }
Property AllowMultipleFieldFilters As Boolean
bool AllowMultipleFieldFilters { get; set; }
Property AllowMultipleFieldFilters As Boolean

Property Value

Type Description
Boolean

true, to use more than one filter for a PivotTable field; otherwise, false.

The default value is false.

Property Value

Type Description
Boolean

true, to use more than one filter for a PivotTable field; otherwise, false.

The default value is false.

Property Value

Type Description
Boolean

true, to use more than one filter for a PivotTable field; otherwise, false.

The default value is false.

Remarks

Set the AllowMultipleFieldFilters property to true to apply multiple filters to a single field in the row or column area of the PivotTable report. If the AllowMultipleFieldFilters property is false (the default value) and you try to apply more than one filter to a PivotTable field, only the last specified filter will be applied.

Examples

Dim worksheet As Worksheet = workbook.Worksheets("Report6")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")

' Allow multiple filters for a field.
pivotTable.Behavior.AllowMultipleFieldFilters = True

' Filter the "Date" field to display sales for the second quarter.
Dim field1 As PivotField = pivotTable.Fields(0)
pivotTable.Filters.Add(field1, PivotFilterType.SecondQuarter)

' Add the second filter to the "Date" field to display two days with the lowest sales.  
Dim filter As PivotFilter = pivotTable.Filters.Add(field1, pivotTable.DataFields(0), PivotFilterType.Count, 2)
filter.Top10Type = PivotFilterTop10Type.Bottom
See Also