pivot table - trying to find A OR B instead of A AND B

D

data analyst

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.
 
M

mo

use the locical =or fuction.

=OR(A1=PEAR,A2=PEAR) WILL RETURN TRUE IF EITHER IS TRUE.

Any help
 
Top