@Sameer_Bajaj  From your initial diagram it looks like all Medicines belong to each state, so a module dimensioned by State and Medicine will suffice; you don't need a LOOKUP at all. &n...

In reality, pursue some fascinating strides here1.in the "Business Forecasting" go to "activities" and afterward tab "Import Data Sources", click the "New Sources" and afterward pick "Interface with A...

Kindly share with me the Module: Commum1Also please tell me in the pic P1 the column containing S1 List Prop is also a different list. Since I see you have used Lookup to pull allocation percentage.&n...

Thanks.I will follow the steps and share my update.

@Sameer_Bajaj  You will have to furnish more details here. Previous month's data is already present in the system and now you want to load current month's data into the system Does your...

@Sameer_Bajaj  I don't think Import will work in your case because Percentages are input at State Level and this has to be distributed evenly thru all the medicines - You don't have the mapp...

No S1 is not the parent. They are different list.I was thinking to use List Property.Can we import List with properties?

Replied to other post of yours

@Sameer_Bajaj  If I understood your question correctly, yes it is possible with filters. Apply filter on the export module and save it. Filter your  logic as per your requirement - appl...

@Sameer_Bajaj  Assuming S1 is a parent of M1. You Just have to create a module with medicine list (M1 thru M10) as a dimension and use Lookup on S(Parent of M) and bring the values into your...