View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
data analyst data analyst is offline
external usenet poster
 
Posts: 2
Default pivot table - trying to find A OR B instead of A AND B

This is how my pivot table is set up in the top left. (example)

Category (Name of Grocery Store) (Cub)
Subcategory (Department) (Fruit & Veg)
product (Name of Product) (Pear)
additional product (Name of Product) (Apple)

The same drop list is available for 'product' and 'additional product'.
Right now, if i put Pear in both boxes, i get only results where people put
pear in both boxes. I'm looking for a way to get records if people put pear
in 'product' OR 'additional product'. Basically an OR instead of an AND.