Advanced Pivot Table Tricks #2 - Distinct Count

#pivottables #powerpivot #distinctcount

We can get count, sum, average and median from our data with pivot tables. But what about distinct counts? You can use "Data model" feature of Excel to get distinct count from your numbers easily. See this video.

For example workbook and resources visit:

chandoo,chandoo.org,Excel,spreadsheets,distinct count,how to get distinct count in excel pivot table,unique count in excel,count distinct excel pivot,