Re: Comibining Common Data in a Pivot Table

Giganews Newsgroups
Subject: Re: Comibining Common Data in a Pivot Table
Posted by:  Debra Dalgleish (d…@contexturesXSPAM.com)
Date: Mon, 15 May 2006

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

Replies

None

In response to

Comibining Common Data in a Pivot Table posted by CrimsonPlague29 on Mon, 15 May 2006