About kiwi.chow@huhtamaki.com

Hi Anirudh,   I have double checked my dashboard filter, this is same as what I did in the model but it doesn't work in conjunction.   I am thinking that should I change the formula in Dashboard Filter like Capture1 as attached ?   Change the OR into AND, it seem Unit Filter and Customer Filter will come up some relation. Isn't it ?   BR, Kiwi ... View more

Hi Anirudh,   Attached is the screenshot of the Filter.   Thanks, Kiwi ... View more

Hi Anirudh,   Yes, I try to refresh the Singapore one but actually remain the same.   I did another test, I select Australia and just select some Australia Customer , but the full list of Australia customer still there after the refresh. (Pic: Capture 11)   I am guessing that is it the step 6 is not using "OR" function ? I have capture all my model setting for your information. Hopefully get have more idea where is my mistake in the model : (   BR, Kiwi ... View more

Hi Aniruch,   Thanks, it seem more close to the end. I have created those things as you mentioned. However, those all three filter checkboxes seem not work in conjunction. When I click Australia and refresh the table, the table can show only Australia data in the right hand side. When I click the Customer table like Singapore Customer, the data table still showing Australia. Is it some step is missing / wrong from my side ?   Also, how can we filter the customer filter when we select the Unit. Like we select Australia and the Customer and Item may only show the related combination.   BR, Kiwi ... View more

Hi Anirudh,   Thanks and I can pass the FINDITEM issue. I am working on step 6 but seem something stupid mistake from my side again ...   I have created those Unit List, Cust List and Item List and it seem not able to pass the formula as you mention. 6. Formula   I think the source should be match but the system say no.   BR, Kiwi ... View more

Hi Anirudh,   Much appreciated your detail guides.   When I FINDITEM, I got some error message there as attached. Is it any step I missed when I create the table ??   BR, Kiwi ... View more

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

Hi Anirudh,   Thanks for your idea. Here is my screenshot and would like to have more advice from you.   Still duplicate, I think the formula should apply when I create rolling forecast model, by using this formula, connect the historical data into rolling forecast model ? IF VALUE <> 0 THEN NAME(ITEM(Country)) & "-" & NAME(ITEM(Customer)) & "-" & NAME(ITEM(SKU)) ELSE BLANK   Thanks, Kiwi ... View more