Excel PivotTable: Count Unique Records | Distinct Count in Excel PivotTable

preview_player
Показать описание
In this Microsoft Excel video tutorial I demonstrate how to perform a count of unique records within a PivotTable. This is known as a distinct count. To enable this calculation you must use the data model.

#microsoftexcel #pivot_table #exceltutorial #exceltips
Рекомендации по теме
Комментарии
Автор

This is straightforward. Thank you, Sir.

hillaryqi
Автор

Hello Sir, thank you for posting these helpful videos. Would you please advise on how to create an automatic numbering system for an excel form using MAX function.

Charlotteba
Автор

Why is the distinct count function not available on Mac Excel?

JeffreyBaird
Автор

The distinct count is coming as greyed out in my system.

Skyboy