Once you have added a helper column, you can then use this new data set to calculate the distinct count. This is an easy way to count distinct values in the Pivot Table as you only need to add a helper column to the source data. Note: If you’re using Excel 2013 and higher versions, skip this method and move to the next one (as it uses an inbuilt Pivot Table functionality – Distinct Count). Distinct names are listed in column B in the above data set. This can be achieved by removing the duplicate values/names and keeping all the distinct ones. So if a name appears three times, it’s still counted as one distinct name. Unique names are listed in column C in the above datasetĭistinct values/names are those that occur at least once in the dataset. This means that all the names that repeat and have duplicates are not unique.
Unique values/names are those that only occur once. While these may seem like the same thing, it’s not.īelow is an example where there is a dataset of names and I have listed unique and distinct names separately. Count Unique Values (not distinct values) in a Pivot Tableīut before I jump into how to count distinct values, it’s important to understand the difference between ‘distinct count’ and ‘unique count’ Distinct Count Vs Unique Count.
Add Data to Data Model and Summarize Using Distinct Count.Count Distinct Values in Excel Pivot Table.
0 kommentar(er)
