In this video, we’ll look at how to get a unique count in a pivot table.
Note: requires Excel 2013+ on Windows
Pivot tables are excellent tools for counting and summing data, but you might struggle to get a unique or distinct count, because this feature is hidden in a normal pivot table.
Let me illustrate with this set of data.
Notice we have a date, state, color, quantity, and a total. I’ll insert a pivot table to summarize the data.
Now, to see how many states we have in the data, I can add State as a Row field.