Advanced Filtering in EJ 1 ASP.NET MVC PivotGrid
28 Sep 2020 / 1 minute to read
It allows to filter and sort the field members in PivotGrid.
Client Mode
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))
Server Mode
In server mode, you can enable the Advanced Filtering and Sorting option in PivotGrid by setting the EnableAdvancedFilter
property to true.
@Html.EJ().Pivot().PivotGrid("PivotGrid1").EnableAdvancedFilter(true)
Sorting
Sorting provides an option to sort the members of a field either in ascending or descending order.
Label Filtering
Label filtering provides an option to filter the members of a field purely based on their caption.
Value Filtering
Value filtering provides an option to filter members based on the total values of the appropriate measure between the members of the level.
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page