problem in using lookup statement
in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data from inventory module which has stock safety exception count as line item and put the data in country summary module.
Now the problem is since inventory module doesn't have country and summary module uses country , the chapter advised me to create another line item called country made in sys08 system module which has product sku as dimensions. when i did that and tried to use lookup to connect the two modules[ inventory and system], it is showing error. Please advise me on how to solve it.