Barb:

The way I like to look at it is that Sales Analysis is the data warehouse and GridView is the reporting tool.

Bruce's description on how to do the report fails to explain one thing. For the calculated fields you need a formula;

if Location = "LAN" then amount else 0

etc for the other three locations. You then need to summarize the report. In the filter you will also want to set a date range.