Lookup Sales Based on drop down list

fssebastian
edited November 2022 in Modeling

Hi, 

 

I need to retrieve the historical sales based on the selected Store from dropdown list of my module.

Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store.

 

Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store (Dropdown list)) 

fssebastian_2-1669193337402.png

 

 

 

But here in the target module I'm getting an error. I think it's because they are in the same list.

 

Target Module Dimension: (SKU, Store, Time(Month) ; Line Item : Historical Sales

 

fssebastian_1-1669193229965.png

 

Please help, thanks.