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