Advanced Filtering and Sorting
23 Mar 20211 minute to read
It allows to filter and sort the field members in PivotGrid.
In client mode, you can enable Advanced Filtering and Sorting option in PivotGrid by setting the
EnableAdvancedFilter property under
DataSource to true.
@Html.EJ().Pivot().PivotGrid("PivotGrid1").DataSource(dataSource => dataSource.EnableAdvancedFilter(true))
In server mode, you can enable the Advanced Filtering and Sorting option in PivotGrid by setting the
EnableAdvancedFilter property to true.
Sorting provides an option to sort the members of a field either in ascending or descending order.
Label filtering provides an option to filter the members of a field purely based on their caption.
Value filtering provides an option to filter members based on the total values of the appropriate measure between the members of the level.