There is a situation where I am trying to find a count of how many unique values are associated with an item on a related table. How can I find this?
Here's the scenario
1 ACME Widgets
1 Quote 1 for ACME Widgets by Paul
2 Quote 2 for ACME Widgets by Paul
The desired output for Paul is
Business Opportunities: 1
Quotes Generated: 2
However, when I run COUNT for opportunties, it shows 2, because two quotes are tied to the opportunity--disregarding that there is only 1 unique business opporutnity.
How can I overcome this obstable and achieve the desired output in bold?