Question:-How to Filter Data in a Microsoft PivotTable View in MS Excel?
Answer:-Easy Filtering of Data in a Microsoft PivotTable View in MS Excel?
There is a better way to select multiple report filters than dragging the filter down to a row. It is quicker to select additional filters directly from the original filter.
1. Select the filter, and then click multiple items at the bottom.
2. The filter selection changes to check boxes. Simply select the boxes you require.