Advanced filtering and sorting

27 Feb 20181 minute to read

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

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

HTML

<template>
  <div>
    <ej-pivot-grid e-enable-grouping-bar="true" e-enable-advanced-filter="true">
    </ej-pivot-grid>
  </div>
</template>

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 total values of the appropriate measure between the members of the level.