In Excel 2013, if you add a pivot table's source data to the workbook's Data Model, it is easy to create a unique count. On this page, you'll see 4 methods that you can use, to get a unique count in an Excel pivot table.Īll four methods are described in the sections below, along with a performance comparison between methods 2 and 3.ġ) In Excel 2013 and later, create a Data Model in the Excel workbookĢ) In Excel 2010, and later versions, use a technique to ' Pivot the Pivot table'.ģ) In Excel 2007 and earlier versions, add column to source data, and Use CountIf functionĤ) OR, if the Power Pivot add-in is installed, use Tutorial, you'll see how to get a distinct count of items in a pivot There isn't a built-in 'Unique Count' feature in a normal pivot table, but in this How many unique salepeople sold each product per region?.How many unique products were sold in each store?.How many unique (distinct/different) customers made purchases in each region?.For example, if you're analyzing sales data, you might have In an Excel pivot table, you might want to count the unique occurrences Four methods, for different versions of Excel. How to count unique items (distinct count) in an Excel pivot table.

Home > Pivot > Calculation > Count Unique Count Unique Items in Pivot Table

How to make pivot table in mac numbers