Try this:

Select Inquiries / Transaction History

Select only "Shipments"

select an appropriate date range

Double-click on the column header and scroll down to add "Sale Amt" to the grid.

Click Load.

You can export this to Excel for analysis. Simple formulae will give you cost per item and revenue per item.

Note: quantities will show as negative numbers since each "shipment/sale" decreases the stock on hand.

Costs will be negative since they are a credit to the inventory asset account.