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

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

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