Excel Reporting

Hi all, 

I'm wondering if anyone can help in how the system could give me a report (I'm currently attempting with the Excel Reports app). 

Example:

I am looking to run a list of Companies with the columns as "Name" and "Total Contacts".



I want the "Total Contacts" to only include Contacts created in the last week. 



I thought the logical way would be to use a section report for Companies. Then user Advanced filter to drilldown into Contacts table and filter by my criteria. 



What that does is only show the companies who have had contacts created within the last week, but when I run the report, the value for "Total Contacts" = Total contacts of all time. 

Any help greatly appreciated here. 

Thank you!