Lookup between two modules with different dimensions

xzhan252

Hi,

I have below two modules:

 

Module CAL04: Page: Business Line, Line Items, Column: Time, Row: Transaction month

Module DAT06: Page: Business Line, Column: Periods, Row: Line Item

I want to have NCO% in module DAT06 to show up in module CAL04 per the "reference period #" line item (e.g any "month 0" cell with have respective NCO% value from module DAT06).

 

I tried to do lookup and sum, both didn't work, I think the issue is I have extra dimension in module CAL04. Can anyone help me on this?

 

Thank you

Jayden   

 

xzhan252

Thank you!