I want to find out how many new clients we had this year. It might be that in the attached list of opportunities won, we sold more than once to the same client. Therefore, one might expect that the number of new clients was less than the number of opportunities listed. We are not looking to remove the clients with more than one entry but count that client as one entry.
Solved by B. J. in 29 mins