Get Distinct Count (Ignore Duplicates) in Pivot Table - Excel #Shorts

preview_player
Показать описание
Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. Here's an Excel #shorts video to show you how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to

#excel
#msexcel
#doughexcel
Рекомендации по теме
Комментарии
Автор

What's the use of "add this data to the data model"?

Rabbani_World_Flock