Reverse mapping

Hi all


I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works perfectly for a standard LOOKUP formula.


I was wondering if there's an easy way to reverse the mapping? I basically want another mapping module with list B as dimension and list A in the dropdown where list A is automatically populated based on the initial mapping.







  • @vd_ghnst 


    If there is a 1:1 mapping then you can say 

    Source Line item from Rev04[FIRSTNONBLANK: Rev04 Container Throughput]


    Hope that helps


    Miz Logix