removing duplicate activity counts in reports
I am creating a bunch of productivity reports and one thing I am struggling with is the consolidation of activities per company name. E.g. if I want to see how many new opportunities my team has created in the past, for example, 7 days, I can build a custom report on a cross data set for contacts and activities, but it will measure by count of ALL activities to contacts created within the specified period and not by count of company names. I want to just see the count of new prospects added.
As an illustration, I might see that the team has had 50 activities in the past 7 days, but only with 5 new prospects as they might be sending and receiving emails from those same contacts. So, how can I just get the count of new company names added in the past 7 days?