Microsoft Excel Tips and Tricks
Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option – Totals and Filters tab and check Allow multiple filters per field.
Credit Chris Menard