Hi Susan,

Use the {Composite Table V8.0C} to select the composite view *IC Item Loc with IC Item. This provides a single record for each item/location pair. Use and IF statement to move the QOH into a separate column for each of your 4 locations
Code:
  =IF({Loc}="ABC", {QOH}, 0)

Then summarize to item.
_________________________
Andrew Bates