create a Saved Item Search Showing Inventory by Location

You need to use Summary Type in your Result fields to return a single line to each Item.

Here are the Result fields you may add:

Field | Summary Type

Name | Group

Formula (Numeric) = CASE WHEN {inventorylocation} = ‘California’ THEN {locationquantityonhand} ELSE 0 END | Sum

This Saved Search will show the QTY On Hand of an Item, just like in the Item record.

I hope this helps!