Skip to Content
0
Former Member
Nov 19, 2012 at 04:04 PM

Losing dynamic filter on EVMBR BPC7.5SP10 NW

18 Views

Hi Gurus,

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

T163 U163

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,

T163 U163

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.

Thanks,

Abhishek Khatti