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