Excel – Turn on Multiple Filters in a PivotTable – Allow Multiple filters per Field Setting

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