Unique values in pivot

[Eric S.]

Hi

I want to display unique customer names in a pivot.
my data source looks like this

customer value
cust 1 10
cust 2 20
cust 1 11

expected outcome would be 2 customers with total value of 31 (21 for cust 1
and 20 for cust 2)
with current pivot settings, my customer count comes to 3 with total value
of 31.

thanks for your help!
Eric

 

[francis]

would the total be 41 instead 31??
and you want to count customer as unique which means
that the count should consider only 1 although the same customer
may appear couple of times?

try this formula for counting customers
=COUNTIF($A$2:$A$9,A2)

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis