Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have zone like this East, North1, North2, North3, South1, South2, West1, West2
i want to it should come in single field Called Region with North, East West South...
if(Region = 'East','East' or
if(Region = 'North1','North2','North3' , 'North' or
if( Region = 'South1','South2' , 'South' or
if(Region = 'West1', 'West2', 'West')))) as Zone
will it work?
please Suggest
if(Region = 'East','East',
if(left(Region,5) = 'North',
if( left(Region,5) = 'South',
if(left(Regionm,4) = 'West')))) as Zone
should work!
This should be done ideally in the script (but can be done too in a calculated dimension)
i want north1 , north2 , north 3 should combine into one
if(Region = 'East','East',
if(left(Region,5) = 'North', 'North'
if( left(Region,5) = 'South', 'South',
if(left(Regionm,4) = 'West','West')))) as Zone
sorry for mistake, it should be like 'East'
HI,
You should create a new table in your script like:
REGIONS:
LOAD * INLINE [
Region, Region2
East,East
North1,North
North2,North
North3,North
South1,South
South2 ,South
West1,West
West2,West ];
Then in your graphs you can use the dimension Region2
Hi Abhay,
see the attached simple example which illustrates Rudolph's suggestion.
Regards
Andy
Pick(Wildmatch(Region,'East','*North*','*South*','*West*'),'East','North','South','West') As Zone