Sold items by my store categories.

[nuggetsbygrant]

I was looking to see how many and for how much I sold of each of my store catogories.  I discovered if I sold more than one item to a buyer when I did the report on sold items by store catogory it included everything that the buyer bought and total those all up.  I wanted to know how many items I sold and for how much but it adds the other items.  If that wasn't bad enough it doesn't even show the price of each individual item sold if a buyer bought more than one item.  They could buy one item in that store catogory and 5 other items in other store catagories and it would total them all.

Does anyone know how to get the indivdual price of what you sold to appear when this happens?