count distinct in Pivot table
 

the data is alike
A
B
C
A
when I count, I want to count how many distinct items, the result of above
data shouls show only 3 (A, B and C).
when I use pivot, the total shows 4 (counting 2 As).
Pls help how to get this done.

A pivot table won't calculate a unique count. You could add a column to
the list, then add that field to the pivot table.

For example, to count unique items in column A, use the following formula:

=IF(COUNTIF($A$1:A2,A2)=1,1,0)

Copy this formula down to all rows in the list, then add the field to
the pivot table.


soe wrote:
the data is alike
A
B
C
A
when I count, I want to count how many distinct items, the result of above
data shouls show only 3 (A, B and C).
when I use pivot, the total shows 4 (counting 2 As).
Pls help how to get this done.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html