Wrong Subtotal in Pivot Table Distinct Count

[clinical]

Hi there,

I am encountering a problem with Pivot Table in Excel. I am trying to get Subtotal of Distinct Counts, but the manual total of the Distinct Count is different from the Subtotal done automatically by pivot table. In the attached picture of the pivot table, you can see that "Blue" is showing a subtotal of 15, while if I do it manually, it adds up to 16. Similarly, "Red" has a subtotal of 15 while if I do it manually, it adds up to 20.

I am unsure why this discrepancy exists and how to solve this problem. Has anyone else experienced this issue and found a solution? Any help would be greatly appreciated.

Thank you!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Wrong Subtotal in Pivot Table Distinct Count
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.