Report To View Item Sales By Geography

Hello All -

I would like to see a report that shows how well our products sell by U.S. State. Also, rather than see a list of individual items, I would like to see the cumulative totals of those items that have the same first four digits in the item number. Our item numbers are 9 digits in length - so for all items that share the same first 4 digits, I would like to know what the cumulative sales are by state.

Help?!

Thanks,

Mike