How to get total orders of each t-shirt design

[goofegolfer]

We are a screen printing business and have an online store...I am having a hard time trying to gather information from our sale to see what shirts we need to order...right now what I have to do is go into the product detail for each shirt and then copy and paste the sales portion of each shirt.  If I use the CSV export this is what I come up with.

 

Color - Dark Heather  Size - Adult Small;0.0714285714286; Color - Dark Heather  Size - Adult Medium;0.142857142857; Color - Dark Heather  Size - Adult Large;0.285714285714; Color - Dark Heather  Size - Adult X-Large;0.357142857143; Color - Dark Heather  Size - Adult 2X-Large;0.0714285714286; Color - Dark Heather  Size - Adult 4X-Large;0.0714285714286;

 

Is there anyway I can change these figures?  What I need from this is how many of each size I need to order.  It should read

Small - 1

Medium - 2

Large - 4

X-large - 5

2XL - 1

4XL - 1

 

I have tried building something through Advanced Export Module, with out success, also tried through the  SQL Manager.   Here is a link to my webstore you see what I am trying to do.

 

http://dengraphix.com/store/17-stars-baseball

 

Thanx

 

 

[NemoPS]

You need a sql query to include the id_product_attribute to match each size. I'd first list all of those combinations, then foreach of them use a query with COUNT(*)