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

G

Guest

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
 

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

Pivot Table - Changing Column Values 2
Pivot Table Values as a % of a Subtotal 1
I need to turn on repeating labels in rows of my pivot table 3
Pivot table to new data sheet? 2
Macro (or equivalent) to display certain pivot table data 8
Pivot Table Calculated Item 2
Calculated Item in a Pivot Table 2
How to sum two columns in a pivot table 1

Top