Hello, I'm trying to do a Saved Search where for my items that includes the Base Price / 25% Off price for both USA and Canada on a single row. My Problem: 1. Many rows for a single item (I'm trying to get a single row containing US MSRP column and Canada MSRP Column) 2. How would I do it if I wanted to add the MSRP as well as the 25% price level all to the same row in a saved search?

CASE WHEN {pricing.pricelevel.id}=1 THEN {pricing.unitprice} END

try adding group by on item. max(USD), max(CAD). max doesn't do anything since there's only a single value.

There is a result selection for “Other Prices”. If you add that, it will show all price level pricing on one line.