Advanced Filtering in EJ 1 Angular PivotGrid

28 Sep 20171 minute to read

It allows to filter and sort the field members in PivotGrid. You can enable the Advanced Filtering and Sorting option in PivotGrid by setting the enableAdvancedFilter property to true.

  • html
  • <ej-pivotgrid [enableGroupingBar]="true" [enableAdvancedFilter]="true">
    </ej-pivotgrid>

    Sorting

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

    sorting

    Label Filtering

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

    filtering

    filtering_dialog

    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.

    valuefilter

    valuefilter_dialog