How do I eliminate duplicates in reports?

[kaylynny]

I am reading the VM_Vendor_Contacts table and there are multiple contacts per company.   

From a reporting perspective only, how can I show only the first occurrence of a company in this table?  

[sachin_namjoshi]

Create a pivot report like example

And Aggregation> Count distinct, in below example is count distinct by user

Regards,

Sachin

[kaylynny]

Thank you for your response.  Unfortunately, I need to show details regarding the row/company, so I must have a list report. 

[SmitP]

Was anyone able to resolve this? I need to show ticket numbers in a list, there should not be duplicate tickets.

[Eivind Sandnes]

Worked for me when counting ITIL-users 🙂