Key Points

• Learn how to calculate distinct counts in a pivot table in Excel.
• Ensure to add data to the data model for distinct count functionality.
• Step-by-step guide on setting up the pivot table and accessing distinct count options.

Introduction

In this video, the presenter explains how to take a distinct count or unique count in a pivot table in Excel. The process begins with preparing your data and ensuring the correct options are selected during pivot table creation. Start here.

Setting Up the Pivot Table

• The presenter demonstrates how to create a pivot table by selecting the data and using the shortcut key Alt+N+V. Learn more.
• It is crucial to check the option "add this data to the data model" to enable distinct count functionality. Check this step.

Calculating Distinct Counts

• After creating the pivot table, the presenter shows how to right-click on the value field and access the value field settings. See the settings.
• The distinct count option is only available if the data model was checked during setup. The video highlights how to view distinct items in different categories, such as countries. Explore the example.

Conclusion

By following the steps outlined in this video, viewers can effectively calculate distinct counts in their pivot tables, enhancing their data analysis capabilities.

Comment Summary & Sentiment

The comments reflect a positive sentiment, with viewers appreciating the tutorial. One user suggested using Urdu for better accessibility, indicating a desire for more inclusive content.