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
items options inside the
filterSettings property in the pivot table.