medium10 pts · first answer countsexcelpivot-tables

Counting unique customers in a pivot

A pivot on order rows shows "Count of Customer ID", which counts orders, not customers. How do you get the number of different customers per region?

A.Add the data to the Data Model and use Distinct CountB.Change the value field setting from Count to Sum insteadC.Sort the Customer ID column before refreshingD.Put Customer ID in both Rows and Values

Discussion 0

Join free to post in the discussion.

Counting unique customers in a pivot

Discussion 0

Related questions