Can you attach a packaged workbook? or at least a screen shot?
If Media is on the columns and Week on the rows shelf does adding Campaign to the columns shelf not work? Or messing with Sub-Totals?
I'm having a hard time picture what you are trying to accomplish. Sorry.
I've attached the workbook. The first tab is the 4 week with grand totals that I would also like to add campaign to date totals to. The second tab is campaign to date totals.
I'm not able to see your worksheet because of the password it asks for when trying to open it, but from what I understand you should be able to add the campaign to date totals to your worksheet instead of having to build multiple worksheets. I'm guessing you have a column that specifies each campaign. Just click on the down arrow for the campaign variable, then select "Subtotals" (in the end, you want there to be a check mark next to "Subtotals"). That will give you the campaign to date information. The grand total will give you the total for all campaigns to date. Hopefully this makes sense! I've attached a screenshot of what I am talking about. It includes the Subtotal as well as the Show Column Grand Total from the Analysis drop down menu.