Easy way to get "Distinct Count" in Pivot Tables

Published: 26 February 2020
on channel: Chandoo
47,367
1k

#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:

https://chandoo.org/wp/advanced-pivot...


Watch video Easy way to get "Distinct Count" in Pivot Tables online without registration, duration hours minute second in high quality. This video was added by user Chandoo 26 February 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 47,367 once and liked it 1 thousand people.