Two filters in a pivot table

C

Clddleopard

I have a pivot table that I'd like to filter for two criteria like an OR
instead of an AND.
I have two fields for animal handlers, keeper 1 and keeper 2. They are
linked to a table called keeper ID.
Sample Records:
Animal Keeper1 Keeper2
Scooter Jane Kim
Tilli Kim Ellen
Cactus Ellen Todd
I'd like to filter for which animals have been handled by keeper 1 OR keeper
2. So I'd like to see which animals Kim or Ellen have handled, resulting in
Scooter, Tilli, Cactus. Or which animals Kim or Jane have handled resulting
in Scooter, Tilli. The Pivot Table filters filter like an AND. Is there a way
to change that behavior?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
modified pivot table using a macro 2
Pivot Tables and Filter Criteria Display 0
VLOOKUP a Pivot Table Filter 0
Slicers and Calculated Items in Pivot Table 2
PivotTable - Filter Row 0
Storing Multiple Selected Pivot Table Report Filter Values 2
Adjust Pivot Table Filter based on a Range 0

Top