Multiple Sort Filters on a Pivot Table

Problem: You can't put a field in your Pivot Table rows AND filter out specific values from that field (or use other filters, like show only the top 10 in that field). Normally, you can just hit the dropdown in your Pivot to fix this - but that dropdown doesn't let you have more than one filter! What if you want to filter out several values at once?

Solution:

• Right-click anywhere in the Pivot, click PivotTable Options

• Click the second tab, "Totals and Filters"

• Check the "Allow multiple filters per field" box.

Example: I want to filter out all rows with "Yellow" AND "Green" in them. Now I can!