Comibining Common Data in a Pivot Table

Hello,

I have the following data:
(The product/part/qty data is being pulled from a company database, and I am
constantly required to add and remove products as they are introduced/expire.)
Product Part QTY
one a 2
one b 3
one a 4
two a 5

I am tring to generate a pivot table that will show me how many different
products part a is used on, but currently when I generate the table it would
show me part A being used on 3 products when actually it should be 2, as it
is used in product One at two different locations in the process(process used
at is extracted from database also)
How can I make it show as being used in 2 Products?????

Thanks in Advanced

A pivot table won't count unique values. Perhaps you could use formulas
outside of the pivot table to count the products per part.

http://www.contextures.com/xlPivot07.html#Unique


CrimsonPlague29 wrote:
> Hello,
>
> I have the following data:
> (The product/part/qty data is being pulled from a company database, and I am
> constantly required to add and remove products as they are introduced/expire.)
> Product Part QTY
> one a 2
> one b 3
> one a 4
> two a 5
>
> I am tring to generate a pivot table that will show me how many different
> products part a is used on, but currently when I generate the table it would
> show me part A being used on 3 products when actually it should be 2, as it
> is used in product One at two different locations in the process(process used
> at is extracted from database also)
> How can I make it show as being used in 2 Products?????
>
> Thanks in Advanced


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks, works great. Appreciate all the help, from everyone, I have been
asked to take on ownership of alot of the databases creation/maintenance of
excel databases recently I have had to really brush up on all my Excel skills

"CrimsonPlague29" wrote:

> Hello,
>
> I have the following data:
> (The product/part/qty data is being pulled from a company database, and I am
> constantly required to add and remove products as they are introduced/expire.)
> Product Part QTY
> one a 2
> one b 3
> one a 4
> two a 5
>
> I am tring to generate a pivot table that will show me how many different
> products part a is used on, but currently when I generate the table it would
> show me part A being used on 3 products when actually it should be 2, as it
> is used in product One at two different locations in the process(process used
> at is extracted from database also)
> How can I make it show as being used in 2 Products?????
>
> Thanks in Advanced