How to add unique count to a pivot table

Tip: How to add unique count to a pivot table

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. 


Related shortcuts



Leave a Reply

Your email address will not be published. Required fields are marked *