Site icon ExcelNotes

How to Add a Filter to the Pivot Table

After making a Pivot Table, you can add one or more filters to customize the data summaries.

Step 1: Drag "Gender" to the "Report Filter" box;

Step 2: In the filter section above the Pivot Table, click the tri-angle to show the drop-down list;

Step 3: Check "Select Multiple Items";

Step 4: Select "M" from the list;

Step 5: Click "OK" at the bottom.

Exit mobile version