•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
Our take
If you're encountering an unexpected result in your Excel PivotTable, you're not alone. In your case, the Distinct Count feature shows 16 instead of the expected 6 unique products from your dataset. This discrepancy can arise from how the data model interacts with duplicates. By checking your PivotTable setup—specifically how you’ve configured the Distinct Count—you can identify the source of the issue. Let’s explore the steps to ensure your PivotTable accurately reflects the unique items in your dataset.
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]
Read on the original site
Open the publisher's page for the full experience