Excel Distinct Count with a PivotTable
Posted on: 03/31/2022
PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers.
To create a distinct count in a PivotTable, there is a box you must check to have this feature enabled in your PivotTable. In this short video, I'll demonstrate a PivotTable without a distinct count, create another PivotTable with a distinct count, and finally show the awesome UNIQUE function. The tip is to select Add this data to the data model when creating your PivotTable.
YouTube video
Chapters/Bookmarks
-
0:00 Intro
-
0:15 PivotTable without distinct count
-
2:10 PivotTable with distinct count
-
4:15 UNIQUE Function in Excel
Create a PivotTable with a Distinct Count
-
Click inside your data
-
Click the Insert Tab and click PivotTable
-
Make sure to check Add this data to the Data Model (see screenshot above)
-
Click OK
-
Drag your fields to the PivotTable field area
-
To do a distinct count, right-click and click Summarize Values By and click More Options
-
Scroll to the bottom and select Distinct Count
Recent Excel articles
Five Methods for Creating Running Totals in Excel
Excel is a powerful tool that offers various features to manipulate and analyze data efficiently. One of the useful functionalities it provides is the ability to create running totals, which can be essential for tracking cumulative sums over a period.
Mastering Conditional Formatting in Excel with Copilot: A Step-by-Step Guide
Mastering Excel is a critical skill for many professionals across various industries. Among the many features Excel offers, conditional formatting stands out for its ability to visually highlight important data. In this guide, we delve into the world of conditional formatting with the help of Excel's Copilot feature.
Categories