Target module with less number of lists
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO).
Target dimension has one dimension EMP and Time and line item that is list formatted (GEO).
I want to bring in the Geo from source to target in this case. Since the target has less dimension, if I were to bring in number, it would give me the aggregated value from the source to the target by default, however, since I have list-formated item I want to bring, the option I am aware of is to bring in the firstnon blank or lastnonblank. So in this case, since my source GEO list has summary method of lastnonblank, my target shows South for Jan.
a. Is there any option to bring in GEO of my choice in this scenario or
b. bring in multiple values in the target. In this example, Sam is tagged in East as well as South. Is there option to bring in both in some way?