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