This sample demonstrates filtering row and column headers either by including or excluding them from the pivot table.
In this sample, any field can be selected from
Fields dropdown list along with its members from be subsequent
Members dropdown list and finally select whether to include or exclude them from filtering. It can be achieved
using the
name and
items options inside the
filterSettings property in the pivot table.
More information on the filtering can be found in this documentation section.