Skip to main content

PivotGroupFilterValues.FindFilterValue(Object[]) Method

Returns a filter value that corresponds to the specified group value.

Namespace: DevExpress.XtraPivotGrid

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

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


public PivotGroupFilterValue FindFilterValue(
    params object[] values


Name Type Description
values Object[]

An array of field values that identify the group value.


Type Description

A PivotGroupFilterValue object, which is a filter value that corresponds to the specified group value; null (Nothing in Visual Basic) if the required filter value has not been found.


Consider a field group that contains three fields - Year, Quarter and Month - and whose filter condition is set as shown in the image below:


The following table demonstrates how to use the FindFilterValue method to obtain filter values by the corresponding group values.

Group Value Method Usage
1994 filterValues.FindFilterValue(1994)
Quarter 3 | 1994 filterValues.FindFilterValue(1994, 3)
August | Quarter 3 | 1994 filterValues.FindFilterValue(1994, 3, 8)

To determine whether the current filter condition allows processing a particular group value, use the PivotGroupFilterValues.Contains method.

See Also