I am trying to make a selection on Product, which should be based on Region. Here is the scenario:
The Region and Product are part of Column. Region has 4 regions, which is displayed using drop downs.
Based on the selected region (which is a property of Product), I need to restrict the Product selection.
I tried the following
Region = Asia Pacific =EVMBR("FINANCE","AFR1","REGION="&T163&"")
The problem is, as soon as I change the region and double click and select the region, I am losing the filter above. After selection,
Region = Europe =EVMBR("FINANCE","EURO1","REGION=Europe")
How do I retain the dynamic filter? Is there any excel option that I am missing or need to change?
I will really appreciate your help.