| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| How do I find the "Show Pages..." Pivot table feature in 2007? | Excel Discussion (Misc queries) | |||
| OLAP Pivot Table - HT Find source data | Excel Discussion (Misc queries) | |||
| Find multiple repeated values in a Pivot Table | Excel Worksheet Functions | |||
| Find first nonblank cell row # in pivot table using MATCH | Excel Worksheet Functions | |||
Threaded Mode
