Lookup between two modules with different dimensions
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?