I have 2 case statements like below. When I run the search, they end up on 2 lines:
Item Reserved USA
123 25
123 10
What I want is 1 line:
Item Reserved USA
123 25 10
CASE WHEN {item.inventorylocation}='Reserved' THEN {item.locationquantityavailable}) ELSE 0 END
CASE WHEN {item.inventorylocation}='USA' THEN {item.locationquantityavailable}) ELSE 0 END
Any idea how to do that?
