Advanced filtering and sorting

It allows you to filter and sort field members in the pivot grid.

Client mode

In client mode, you can enable the advanced filtering and sorting option in the pivot grid by setting the enableAdvancedFilter property to true.

  • html
  • <div id="PivotGrid1"></div>
    <script>
        $("#PivotGrid1").ejPivotGrid({
                //...
                enableAdvancedFilter: true
        });
    </script>

    Server mode

    In server mode, you can enable the advanced filtering and sorting option in the pivot grid by setting the enableAdvancedFilter property to true.

  • html
  • <div id="PivotGrid1"></div>
    <script>
        $("#PivotGrid1").ejPivotGrid({
            //...
            enableAdvancedFilter: true
        });
    </script>

    Sorting

    Sorting provides an option to sort the members of a field either in ascending or descending order.

    Sorting options in JavaScript pivot grid control

    Label filtering

    Label filtering provides an option to filter the members of a field purely based on their caption.

    Label filtering options in JavaScript pivot grid control

    Label filter dialog in JavaScript pivot grid control

    Value filtering

    Value filtering provides an option to filter members based on total values of the appropriate measure between the members of the level.

    Value filtering options in JavaScript pivot grid control

    Value filter dialog in JavaScript pivot grid control