Advanced filtering and sorting

24 May 20191 minute to read

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

Client mode

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

HTML

<div id="PivotClient1"></div>
<script>
    $("#PivotClient1").ejPivotClient({
        dataSource: {
            //...
            enableAdvancedFilter: true
        }
    });
</script>

Server mode

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

HTML

<div id="PivotClient1"></div>
<script>
    $("#PivotClient1").ejPivotClient({
        //...
        enableAdvancedFilter: true
    });
</script>

Sorting

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

Label filtering

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

Value filtering

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