Sum repeating rows as one

Thanks Herbert.   I think this may get me close, but with the end in mind - perhaps a different example will help illustrate the challenge I am having.  I have a flat dataset but there is a hierarchical relationship within the dataset of:

Advertiser>Campaign>Order or put another way...Orders are properties of a Campaign, Campaigns are properties of an Advertiser.

Since the information is presented "by day" for each row, there is certain data from my source system that is "static", and other data that needs to be summed, etc.  See the sample dataset below, along with the questions I am trying to answer and how I would want to present it in Power BI.  In the past, I would have pivoted it in Excel (also below) and I can't quite put my thumb on whether I should leverage a "Group By" or "Pivot" function in Power BI (which I can't quite figure out anyway).

Pivoted below, this is what I am looking to reproduce in a more visual way in Power BI:

Basically, the questions I am trying to answer are as follows:

• How many Orders have I delivered against my Order Goal?
• How many Orders have I delivered against my Camapign Goal?
• What/How Many Orders belong to a Campaign?
• What are my Toal Order goals for all my campaigns (1,000)?  (Power BI would make this look like 5,200)

Hopefully this sheds some more light on my current limitation.  I am sure it is a rather simple solution, but being a newbie - I am trying to get out of my own way (with your help).  Thanks.