Blazor Pivot Table Example - Value Filtering
Grand Total |
|---|
Grand Total | No records to display |
Properties
Fields:
|
|
Measures:
|
|
Condition:
|
|
Value 1:
|
|
This sample demonstrates how to filter row and column headers based on a specific measure and the grand total. Various conditions can be applied including equals, less than, greater than, and between comparisons.
In this sample, select any field from the Fields dropdown list along with a value field from the Measures dropdown. Choose a condition from the Conditions dropdown list, enter comparison values in the Value1 and Value2 input fields, and apply the filters to view the field headers filtered based on the grand total.
Value filtering can be applied either programmatically or through the UI. To enable value filtering in code-behind, set the AllowValueFilter property in PivotViewDataSourceSettings to true and use PivotViewFilterSetting with the following properties:
| Name | Specifies the normal field to filter. |
| Type | Specifies the filter type. Set to "Value" for value filtering scenarios. |
| Measure | Specifies the value-based field on which the filter will be applied. |
| Condition | Specifies the operator type such as equals, greater than, less than, between, etc. |
| Value1 | The first comparison value. For example, select "DoesNotEquals" and enter "9590" to exclude grand totals with this value. |
| Value2 | The second comparison value for range-based conditions like "between" and "not between". For example, enter "9590" and "17500" to filter grand totals within this range. |
To apply value filtering through the UI, navigate to the "User Interaction > Field List" sample and open the filter dialog. For detailed API information, refer to the Field List sample description.
For comprehensive information about the value filtering feature, refer to the value filtering documentation.