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

nnnn

Microsoft Excel Tips and Tricks

nFilter 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.nnnn

Credit Chris Menard

n