Group or merge dimension

[gauthamchilled]

hi,

I have two dimensions or two levels and want to make it one. something like the attached example. how can I achieve this?

only for specific counties, I want to use the continent name instead of displaying all the countries in the pivot table.

Pls help

Gautham

[tresesco]

Load *, If(continent='Asia', country, continent) as NewDim inline

[

continent,country,sales

Asia,India,120000

Asia,Singapore,540000

Asia,Thailand,2434321

Europe,Netherlands,1234123

Europe,Norway,23422323

Africa,Uganda,123123

];

[Anonymous]

I dont think that this exactly you can do same but workaround like:

1) You can use Statistics Object to represent in same way, see this:

Newbie question - Showing statistics using objects

2) Continent&'-'&Country as NewDim  //Composing both the fields

[Anonymous]

Ohh, misunderstood the requirement. see Tresesco suggestion

[gauthamchilled]

Tresesco,

Thanks. I want to do for several other dimensions not just for Asia, but to be grouped under Newdim. How can I do that.

i.e Based on second dimension values I want to group them and show as new dimension.

Thanks for the help.

Gautham.

[Anonymous]

You need to hardcode in the same way with multiple if statements like:

If(continent='Asia', country,

If(continent='XYZ', country,

If(continent='ABC', country,

and so on....
continent))) as NewDim

[tresesco]

Try like:

If(Match(continent='Asia','OtherContinent1' , 'OtherContinent2') country, continent)