•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel PivotTable Distinct Count shows 16 instead of 6 unique items
My previous post was deleted
I'm testing Distinct Count in Microsoft Excel using a PivotTable and something doesn't make sense.
I created a simple dataset with a single Product column containing 16 rows, but many of them are duplicates (Coke, Pepsi, Sprite, Water, Milk, Bread). There should only be 6 unique products.
I created the PivotTable like this:
- Insert → PivotTable
- Checked Add this data to the Data Model
- Dragged Product → Rows
- Dragged Product → Values
- Changed Value Field Settings → Distinct Count
But the PivotTable still shows Distinct Count of Product = 16, which is just the total number of rows.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#large dataset processing
#financial modeling with spreadsheets
#PivotTable
#Distinct Count
#Microsoft Excel
#Product