Creating Sales Reports

Is there a way to create a sales report that will tell me total sales by state and also total number of shipments by state? The sales by state report is only giving me total sales by state. I need to know what was shipped to those states.

Sales by date and then do a pivot table by state. (There are loads of good pivot table tutorials on the web.)

Sales Detail X if you need to know the SKUs too.