Soultion for Distinct count Issue

Question

hi i am using pivot table for distinct count in Microsoft excel 2013 version. In main data there i am not added any data, even though the distinct count value is showing 1. Please give a solution if possible.

Answer 1

Hi PRODUCTION ACCOUNTANTTRLS,

Thank you for posting in this community.

To narrow down this issue, it’s first recommended to try the steps in the following third-party article:

Count Distinct Values in Excel Pivot Table (Easy Step-by-Step Guide) (trumpexcel.com)

***Disclaimer:****Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*​According to my research and test, I am afraid this issue may be related to your workbook or your Excel app.

If the issue persists, you may try to create a new Excel workbook to see the result. If the issue doesn’t occur in the new workbook, it means that your current workbook may be corrupted. Given this situation, you may try to copy and paste the content form the ole one to the new one.

If the issue also happens to the new created workbook, it means this issue should be related to your Excel app. And you may try the following methods:

Method 1:

Please open Excel safe mode to identify whether the issue is related to some third party add-ins.

If you can open these files immediately using Excel safe mode, that means the issue might be due to add-ins. And please to refer to steps in this article to remove all add-ins in Excel to see the result.

Method 2:

Please  perform an Online Repair for Office.

If the above suggestions don’t help. Feel free to contact me.

Best Regards,

May

Answer 2

Hi, PRODUCTION ACCOUNTANTTRLS

May I know if you need further help?

If so, please feel free to contact me. And I will further assist  you.

Best Regards,

May

Answer 3

Hi,

It is counting a blank cell as 1. Take the Vehicle number to the Report filter section of the Pivot Table and uncheck Blank in the filter drop down.

Answer 4

Or try doing the distinct count on the date field.