Pivot Table Q: Creat using fieldA valueB OR fieldC valueD?

J

Jan K

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

Debra Dalgleish

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

Jan K

Debra,

Thanks. That might work - the only problem is that the number of records
change with each refresh...but it has definitely given me something I didn't
think about. I have a VBA function that works on the data anyway - I could
modify that to do the comparison on these fields update the column...

That just may work!

Thanks so much!
 
Top