Filtering in RadPivotGrid is switched on/off by the AllowFiltering property. When turned on it will make RadPivotGrid display a tiny filter image beside each field’s name. This is the fields filter button which opens up the filter window. The latter allows the user to exclude data items based on unique key values or apply a wide range of filter operators that fall within two categories: Label and Value filters.
1. Label filters Label filters control which groups for a given field will remain in the pivot data view after grouping has been performed. If, in the current example, you need only the groups for the White color, you should apply an Equals label filter on the Color field.
2. Value filters Value filters, for their part, allow filtering operations to be performed on the aggregate results. If, again illustrating with the current example, you need only the data where the total Sum of Quantity for each Class does not exceed 5000 you should apply a value filter on the Class field with a LessThanOrEqual filter operator and the corresponding filter value.
3. Report filtersReport filters are applied on fields that do not participate in the grouping of the data but are still present in the underlying data source. Report filters allow the exclusion of selected field items from the data prior to its grouping. In order for a pivot grid field to become eligible for report filtering it should be added to RadPivotGrid’s fields collection as a PivotGridReportField. That will effectively make it part of the grid’s filter zone and make report filtering applicable to it. If, for example, you need to perform the grouping only on items which SafetyLevel is either 1000 or 800, you should apply the corresponding report filter to the SafetyLevel field in the filter zone of the grid.