country maping

[soniasweety]

Hi all,

omar bensalem

i want to map the country values to limited. how can achieve this?

i have  region and country

region:

Americas 

AsiaPacific

EMEA

in country i have so many but my requirment is   i want to show in country list   if i select  EMEA ,Americas,AsiaPacific , only below criteria should come.

In americas - UnitedStates,Canada ,OtherAMS

in AsiaPacific-  India,China, OtherAPJ

in EMEA - Germany,UnitecdKingdom ,OtherEMEA

[YoussefBelloum]

Hi,

you can try to use a where clause on the Country field, like this

table:

load

.

.

FROM

WHERE Match(Country,'UnitedStates','Canada ','OtherAMS','India','China','OtherAPJ','Germany','UnitecdKingdom ','OtherEMEA');

[soniasweety]

Not working sir.

youssef belloum

in country listbox   rest of the country's is not showing like

OtherAMS

OtherAPJ

OtherEMEA 

[soniasweety]

Hi Avinash R

Tresesco B  any idea on this?

[Frank_Hartmann]

Maybe like attached

hope this helps

[soniasweety]

is there any other way in scripting   

i dont want to use caluclated dimension    we need to use direct dimension itself

[soniasweety]

cant we achieve throguh this where clause?

FROM

WHERE Match(Country,'UnitedStates','Canada ','OtherAMS','India','China','OtherAPJ','Germany','UnitecdKingdom ','OtherEMEA');

[avinashelite · Accepted solution]

Create an new Country field like this

IF(Region='Asia Pacific' and (Country='India' or Country='China' ),Country,

if(Region='Asia Pacific' and (Country<>'India' or Country<>'China' ),'OtherAPJ',

if(Region='Americas' and (Country='United States' or Country='Canada' ),Country,

if(Region='Americas' and (Country<>'United States' or Country<>'Canada' ),'OtherAMS',

if(Region='EMEA' and (Country='Germany' or Country='United Kingdom' ),Country,

if(Region='EMEA' and (Country<>'Germany' or Country<>'United Kingdom' ),'OtherEMEA',Country

))

)))) as Country_NEW,

[YoussefBelloum]

so you want to limit Country values only on selections ?

[soniasweety]

i want to use country in pivot table when user select region  the respected country values should show in pivot table.