Advanced filtering and sorting
24 May 20191 minute to read
It allows to filter and sort the field members in the pivot grid.
You can enable the Advanced Filtering and Sorting option in the pivot grid by setting the enableAdvancedFilter
property to true.
<div class="cols-sample-area">
<ej:pivotGrid id="PivotGrid1" enableAdvancedFilter="true" enableGroupingBar="true">
//...
</ej:pivotGrid>
</div>
Sorting
Sorting provides an option to sort the members of a field either in the 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 the members based on total values of the appropriate measure between members of the level.