If I have customer IDs in a pivottable, how can I just sum associated unique values?
If I have customer IDs in a pivottable, how can I just sum associated unique values?
My suggestion using an auxiliary column
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)
Show what you want to achieve. That's what I proposed is the sum of unique customer value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks