Hard to think of a good title for this.

 

I have a table with Agents and Referrals. The data shows in subsummary parts which are sorted by Agent.

 

It's easy to get a count when Agent = Referral.

 

However, is it possible to get a count of Referrals over the whole found set when sorted by Agent?

 

For example, Smith was the Agent for 10 records.

Smith was also the Referral for 8 records, 3 where Smith was the Agent and 5 where Jones was the agent.

 

On the subsummary part, sorted by Agent, I can get the 3 for when Smith is the Agent and Referral. How can I put on that same part that Smith is the Refferal for 8 records in the found set?

 

I was thinking of maybe Execute SQL but I don't know enough SQL to write a meaningful statement. Or should I go with that?

 

Thanks!

Nevermind. Decided to create an additional relationship and table to handle this.