Has anyone built an inventory valuation report (allows snapshot) where the columns are the locations?

This is how I got locations as columns in a saved search

case when {inventorylocation.id}='1' then {locationquantityavailable} else 0 end

Hope it helps

I forgot to mention I need it in the root parent currency. Using an item search makes use of subsidiary base currency

Use Analytics. You can create a data set of everything you need and you use the workbooks to represent the data much better then any saved search or report

I will try that. Hopefully it supports use of root parent currency

Use a pivot and you can make it look something like this