Because the pivot table is based on the Data Model, you now have Distinct Count.Īfter you select Distinct Count, the pivot table shows a distinct count of customers for each sector.
At first, the Summarize Values By looks like the same Sum, Average, and Count that you’ve always had. Select a cell in the Count of Customer column.
