Categorized in: 
Show Unique Count in Salesforce Reports
May 15, 2024 by melanie.jones@cu.edu
Reports can often have the same contact listed numerous times, so identifying the unique count is important to confirm the Report criteria is accurate. Having a total 9,000 unique contacts when expecting 250 is an indicator of incorrect criteria and should be investigated.
To show the Unique Count:
- Edit the Report
 - In the Contact ID column header, click the down arrow
 - Select Unique Count in the dropdown
 

- Run the Report to see the Record Count versus the Unique Count
 

IMPORTANT
- Do not leave the Unique Count enabled if sending as doing so will make it fail.
 - To remove a unique count:
	
- Edit the Report
 - In the Contact ID column header, click the down arrow
 - Select Remove Unique Count in the dropdown
 - Save the Report
 
 





