Create a report view based on its criteria
I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target)
The image below is my mapping, basically, each Lane is connected to each Slottage Type based on each column.
eg: if a lane is AA1AO "SC In - Consortium" should appear in the line item "Chartered In Exp - Initial Slots Type" and Line Item "Chartered out income - initial slots (type)" will have "SC out - Consortium" etc.
I have already created a mapping as per below image
However, my goal is to let it map automatically based on the code rolling up to the lane (revenue lane) dimension.
Below imagine is my source data.
each code on the left are link to its lane
I'm not sure what logic to use here.