• Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • Fabric
  • Fabric Dark
  • High Contrast
Theme Selection
Mode Selection
*Translated by Google Translator.

Example of Label Filtering in ASP.NET MVC Pivot Table Control

This sample demonstrates filtering row and column headers based on their text. The different conditions that can be applied to the text are equals, begins with, ends with, contains, etc.

Value 1:

In this sample, any field can be selected from the Fields dropdown list. Further, choose an option from the Conditions dropdown list, enter the values in Value1 and Value2 input textbox and apply the same to view the field headers filtered based on the text.

Label filtering can be applied either through code-behind or UI. To achieve this in code-behind, use the filterSettings object in the pivot table along with the following properties.

name : Specifies the normal field.
type : Specifies the filter type and it should be "Label" in this scenario.
condition : Specifies the operator type like equals, greater than, less than, etc.
value1 : Gets the text to view the filter result. For example, select "DoesNotEquals" and enter "Germany" to exclude this country.
value2 : For conditions like "between" and "not between", this option will be enabled. Enter both start and end text to view the filter result. For example, enter "Germany" and "States" to filter the countries within this range.

To achieve label filtering through UI, navigate to "User Interaction > Field List" sample and open the filter dialog to experience the same. For API details, refer to the "Field List" sample description.