Lookup from Different Dimension


I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type.

I want to lookup Exhibition Year in Target Module based on Exhibition Year Season in Source Module. So the result of target module will become like this:

I am using formula in Target Module like below:

I_Order Creation.'Exhibition Year' [LOOKUP: I_Order Creation.'Exhibition Year Season']

But it gets error : Format used for lookup doesn't match any dimension of the source.

Do you have suggestion how to resolve this?

Thanks in advance


  • Hey @rachmitadhila .

    Try Using Firstnonblank or Last nonblank instead of Lookup ['Test 1'.Exhibition Year[FIRSTNONBLANK: 'Test 1'.Exhibition Year Season, FIRSTNONBLANK: 'Test 1'.'Item(SKU)']]

    Hope Its Helps

  • @rachmitadhila
    Formula Exhibition Year[FIRSTNONBLANK: 'Exhibition Year Season']