Editing a Report Design

[cstuckey]

I'm trying to add another total to my report. Right now I show Monthly Sales By Region. I want to add another grouping above the regions. I want my report to look like this:

Japan East Region Totals
Japan West Region Totals

Japan Region Totals (includes Japan East and Japan West Regions)

 

[rocket]

Insert two SubReports in the Report Header above the "Japan Region Totals" which I assume is in your current report detail.
One Subreport will be bound to a "Japan East" query you will need to make. And likewise for the second Subreport and "Japan West" query.