Custom Report for Inventory Value by Location

You cannot, because custom reports include transactions, not balances. Your desire is already in the ideas category: Inventory value movement per location