Easy way to get "Distinct Count" in Pivot Tables

Опубликовано: 07 Октябрь 2024
на канале: 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...