This sample demonstrates filtering row and column headers either by including or excluding them from the pivot table.
|
Fields:
|
|
|
Members:
|
|
|
Filter Type:
|
|
|
|
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.