Lookup Sales Based on drop down list

edited November 2022 in Modeling



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)) 





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




Please help, thanks.