Count unique values in PivotTables in Excel using the new Distinct Count function.
When working with PivotTables the Count function will count all occurrences of a value. However, you may be trying to answer how many unique products were sold in a country, or how many unique customers are in that country.
This video looks at answering such questions by using the Distinct Count function in Excel PivotTables.
Find more great free tutorials at;
computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► linkedin.com/company/18737946/
Instagram ► instagram.com/computergaga1/
Twitter ► twitter.com/computergaga1
- Count Unique Values in PivotTables in Excel ( Download)
- How to add unique count to a pivot table ( Download)
- How To Count Unique Items In Pivot Table In Excel ( Download)
- Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column ( Download)
- Get a Unique Count of Items in a Pivot Table ( Download)
- 2 Quick Ways To Calculate Distinct Count With Pivot Tables ( Download)
- Excel Distinct Count with a PivotTable ( Download)
- Count Unique (Distinct) Items in Excel Pivot Table ( Download)
- How to count unique values Excel ( Download)
- Finding Unique Values with a Pivot Table ( Download)
- Pivot Table Count Unique Values Excel 2010 ( Download)
- Find Unique Count in Pivot Table ( Download)
- Excel - Do a Count of Unique Values | Text and/or Number | Get a Count of Unique Values in Excel ( Download)
- Excel Pivot Table Unique or Distinct Values ( Download)
- Excel PivotTable Calculated Items + the EASY way to Distinguish them from Calc. Fields ( Download)
