Filter by selection

Selection filter can be applied via UI in the following ways:

• Using the filter view
• Using a context menu

Using the filter view

Step 1. Open the filter view by clicking the field’s name or using the field’s context menu. You can resize the filter view using its window borders.

Step 2. Use the checkboxes to select field members that should be displayed or hidden.

You can also filter members using the search box. For more details, refer to the Advanced tips guide.

The screenshot below shows an example of a filter configuration:

Step 3. Once the filter is configured, click the APPLY button to save your configuration.

Using a context menu

Open a field member’s context menu and choose one of the following options:

• Filter by the member. Create a selection filter that shows only the chosen member. 
• Exclude the member. Create a selection filter that hides the chosen member.

To set or change the filter at runtime, use the setFilter() API call:

pivot.setFilter("Country", {
  members: [
    "country.[poland]",
    "country.[uk]",
    "country.[ukraine]",
  ],
});

You can view the existing filter configuration using the getFilter() method.

Live example

If the filter by selection contains only non-existent members, it is ignored and all the field members are displayed. To change this behavior and show an empty grid, see the Advanced tips guide.

You can clear all filters from a field using the clearFilter() API call. For example:

pivot.clearFilter("Country");

Live example