unique value in report - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Somasundaram SSomasundaram S 

unique value in report

how to displaya  unique value in standrad report, could you please suggest me
Pritam ShekhawatPritam Shekhawat
Unique value for which fields? Can you describe more about it?
Somasundaram SSomasundaram S
I want account field as Unique value
Pritam ShekhawatPritam Shekhawat
As of you can't do this. You can promote and upvote this idea here Report Option for Distinct/Unique Records (https://success.salesforce.com/ideaview?id=08730000000BrYLAA0)  But if you want to count the unique records then you can do this. Here Steve Mo gives an awesome idea how to do this . Take a look here https://success.salesforce.com/answers?id=90630000000gkCLAAY
Somasundaram SSomasundaram S
How about other field ? for example i will make unique by id , is it possible could you please suggest me
Pritam ShekhawatPritam Shekhawat
Yes, that is another option that you can use Vlookup to prevent create duplicate records for Account or using a custom field where you can store the Account Name and make that field as unique in Salesforce. 
PS: You don't need to make record Id to unique in Salesforce because Id always unique in Salesforce for records.
Geoffrey FlynnGeoffrey Flynn
If you run an Accounts report each account will only show up once - which is kind of the same as unique.

Maybe a screenshot would help here to explain what you are trying to accomplish
Somasundaram SSomasundaram S
I have account object and task child object, am using five 9 and making call and creating activity record on account object , account object has lead field, if the lead field check box is enabled or if the call activity result contain lead am generating report, in the below example the record has both lead qualified and also call result contain lead word. 
thats why it display 2 times, here i want to have unique record . Please advise


User-added image
Vineet KumarVineet Kumar
What happens when you summarize the report based on the Account Name?
Somasundaram SSomasundaram S
summarise didnt helped me i created group and i had a count field and i grouped account and summarised count in conditional highlight i put largest count  = 1 

some where am missing here
User-added image
Geoffrey FlynnGeoffrey Flynn
You're up to 4 questions on basically the same topic now.  It's not going to happen with standard reports.  If you want a particular field to appear, you'll need to add it to the Account - which I've explained how to do in one of the other questions.  At that point, you'll just run an Accounts report type so that each account only shows once
Somasundaram SSomasundaram S
I already started the coding to do using VF pages . Thanks a lot for all your help.