Filter API

Community Technology Preview (CTP)

Amount Count		Year Quarter Month
Region	Country	2017		2018		2019		Grand Total


		Amount	Count	Amount	Count	Amount	Count	Amount	Count
Africa		43620	26	45200	28	22020	11	110840	65
Asia		189190	41	200865	44	111540	20	501595	105
Australia		101475	31	76130	27	42270	13	219875	71
Europe		215115	54	216425	55	83635	21	515175	130
North America		229645	79	204205	67	72925	27	506775	173
South America		97845	38	100480	42	50315	17	248640	97
Grand Total		876890	269	843305	263	382705	109	2102900	641

The DevExpress Blazor Pivot Table allows you to filter data in code. To apply filter criteria, create a criteria operator object that specifies a filter expression and send this object to the SetFilterCriteria method. When you call this method, the Pivot Table clears all filters applied previously. When a filter is applied, the Pivot Table raises the FilterCriteriaChanged event.

To obtain currently applied filters, use the GetFilterCriteria method.

In this demo, the Tag Box component allows user to select continents. We create a criteria operator object based on the Tag Box's selected value/values. To apply the criteria operator, the SetFilterCriteria method is called.

For additional information, refer to the following topic: Filter API.