Creating a calculated table from other tables

I am trying to create some custom reporting that connects our campaigns with opportunities created.  We have a few methodologies we use but I am having difficulty getting the structure down and wondering if someone can help me with the first one.  Here is what a SQL query would look like with the outcome I need:

SELECT CampaignMember.Campaignid, Opportunity.id, CampaignMember.id

     FROM CampaignMember,Opportunity

     WHERE CampaignMember.CreatedDate < Opportunity.CreatedDate

    OUTER JOIN CampaignMember.Account_Id_Case_Safe__c = Opportunity.Account_Id_Case_Safe__c

My relationship looks like this below:

What I am trying to do is create a new table that will allow me to link opportunities to the campaign so I can ultimately report out like this:

Where I can show total amount of opportunities tied to each campaign given this approach.  Then if I wanted to, I could drill down to see which opportunities and accounts make up that amount (so I don’t just want to use a SUM function in the formula or a single calculated column).

Any help would be much appreciated as most of the help docs I have seen relate to calculated columns or an external SQL database.  Thanks in advance.