sum unique values in pivottable

[stephme55]

If I have customer IDs in a pivottable, how can I just sum associated unique values?

[stasinek]

My suggestion using an auxiliary column

[stephme55]

You have two criteria (customer/value) I'm just concered about one field, customer. So it would identify just the unique values in that one field (without powerpivot please)

[stasinek]

Show what you want to achieve. That's what I proposed is the sum of unique customer value