Lookup two different dimension

edited November 2022 in Modeling



I have attached a sample Modules that I have in my model:


I want to retrieve the Quantity data from Module 1 to Module 2. but they have different dimensions. As you can see below, the dimension for Module 1 is Unique Code List, and Month (time) but in Module 3, the Dimensions are Active Skus , and Accounts. 






I tried using the formula : 

Module 1.Quantity[lookup: Module 3.Account, lookup: Module 3.Active SKUs] but it didn't work, 
Error: Format of Mapping used for lookup doesnt match any dimension of the source.
Can anyone help me with this ?
Thank you 


Best Answer

  • fssebastian
    edited November 2022 Answer ✓

    Oh, I have solved this by using SUM instead of Lookup 🙂