Skip to main content
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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

bool AllowMultipleFieldFilters { get; set; }

Property Value

Type Description
Boolean

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

The default value is false.

Property Paths

You can access this nested property as listed below:

Object Type Path to AllowMultipleFieldFilters
PivotTable
.Behavior .AllowMultipleFieldFilters

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.

Example

View Example

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

The following code snippets (auto-collected from DevExpress Examples) contain references to the AllowMultipleFieldFilters property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also