That works table is only generated when the report is run. Normally the table either does not exist or is empty.  You might want to try going to Inventory, Explore, Item Transactions View, add any other columns you need, filter as needed and then export to Excel 

Raw data for that report is the table SO_SalesHistory.  (You cannot query a work table directly).

Of course, if you need values from the customer / item (like customer name / item description) you'll need to link those in, and the data only includes revenue / cost, so you'll need to calculate the gross profit yourself.

Thanks Kevin. I looked at the SO_SalesHistory and just wanted to make sure I have the correct logic to get the TotalDollarsSold and TotalGrossProfitPercent.

TotalDollarsSold equals (total DollarsSold per Item per Customer) from SO_SalesHistory.

TotalGrossProfitPercent equals (total DollarsSold per Item per Customer - total CostOfGoodsSold per Item per Customer) / (total CostOfGoodsSold per Item per Customer)

Are these logic correct? Thanks