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

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.
--
Jan Kaufman
ABB Inc.
Ohio, USA

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

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

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

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!
--
Jan Kaufman
ABB Inc.
Ohio, USA


"Debra Dalgleish" wrote:

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