Hi Anirudh, Sorry to my late reply, just busy on other task last week. I am trying to do the step one by one. I have created a new model to split unit, customer and item (Capture 1 & 2). Sorry that I am not quite clear how to process the next step. Then create 3 list formatted items, one each for unit, cust and item. Fill them up with FINDITEM(dimension, code) formulas The final step is applying a filter to show only the relevant combinations Should I create another 3 formatted line items in the same model ? Or I should create a new generate lines for customer / unit / item ? I was thinking how it work of the combination. Beside item, I may also have another group related to the item / customer. For example, (Capture 3) unit is the lowest level but we have region in the upper level item is the lowest level but SOP Family > SOP Sub Family is the upper level of item Customer (Account) is the lowest level but Category and Key Accounts is the upper level. Sometimes, people want to input the data in Key Account level instead of account level or SOP Sub Family level instead of item. How can we setup the filter for that ? Maybe my question a bit complicated ... BR, Kiwi
... View more