Working with Reports

Using the "RevenueByRegion" query, build a report that shows revenue totals for states, subregions and regions. Organize the names of the states alphabetically $($in ascending order$).$ In $3$ the footer for each region group and for each sub$-$region group and for the entire report, display the total appropriate revenue total. Name the report "Revenue By Region" $($without the quotes$).$ When complete, your report should resemble the following: $[22$ points$]$

Revenue By Region

Region

Midwest

SubRegion

StateName

StateName

Revenue

Launc

to Res

In the

sate a

Click c

magic

lect Q:

Choos

report

railable

Move

Reven

East North Central

Illinois

Indiana

Michigan

Ohio

Wisconsin

East North Central Total:

West North Central

Pacific

$25,710\mathrm{.}94$

$22,958\mathrm{.}66$

$29,389\mathrm{.}84$

$37,888\mathrm{.}06$

$12,687\mathrm{.}37$

$128,634\mathrm{.}88$

$128,634\mathrm{.}88$

$850\mathrm{.}97$

$66,166\mathrm{.}29$

$1,687\mathrm{.}48$

$6,644\mathrm{.}89$

$18,708\mathrm{.}28$

$94,057\mathrm{.}92$

$137,327\mathrm{.}71$

$771,758\mathrm{.}37$