Income Statement by location

We need A P&L Statement, by Location Code, on one spreadsheet. I attempted the cross Tab reporting, as well as attempting to writ sub reports for each location. The issue is that I am unable to isolate the Location when listing the GL Account History.