Inventory Valuation report Sort question

I'm looking for assistance on an Inventory Valuation Report. I'd like the report to sort via valuation. The highest values descending to lowest. I can't export to Excel and sort that way because of serial numbers. 

Does anyone have ideas on how to achieve this, or to get the same results using a different report? 

Thank you for your assistance. 

BG