You can't do that in the pivot table, but you could add a field to the
souce data and check each record for a match in either field.
Add this new field to the page area of the pivot table, and filter for true.

Jan K wrote:
Hello!

Typically, Pivot table recods are selected by performing a UNION between the
fields selected (page fields) - i.e., if using two page fields, only those
record that meet BOTH conditions are included in the pivot table.

I would like records that meet BOTH values to be included - i.e,. fieldA =
valueB OR fieldC = ValueD.

Is this possible?

I tried all sorts of things, but couldn't see anything to help me with this
one!
Thanks in advance.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html