Unique values in pivot
 

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

Unique values in pivot
 

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




"Eric S." wrote:

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