Hello everyone,
I am trying to figure out the best way to do this but I am not quite sure.
I have three tables, "Lead", "Account", and "Opportunities."
What I am trying to do is show a count of how many Accounts and Opportunities were created (each table has a create date) that matches the Lead, so something like this:
-----------Account-----Opportunity
Lead1: 1 2
Lead2: 2 3
Lead3: 1 1
Something like that. The Account and Opportunity tables each have a LeadSourceID that matches with the Lead table.
Any suggestions??