Lookup two different dimension

fssebastian
fssebastian
edited November 2022 in Modeling

Hi,

 

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. 

 

 

fssebastian_1-1668645036325.png

 

 

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 

 

Tagged:

Best Answer

  • fssebastian
    fssebastian
    edited November 2022 Answer ✓

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

Categories