Excluding the value from a dimension

[#1]

Imagine North,East,South and West are the area and A,B,C and are the groups which are there in each of the area. What I want to do is I want to exclude B group only from the East area. Rest of the area can have all the groups. I want to do this filteration at the dimension level.

Could you please help me out!

I wrote the below code to to exclude East from the Area. I don't know what is the code I have to write to exclude B Group only in East Area

=if(Area<>'East',Area)

----------------- Data for your understanding -----------------

Area

North

East

South

West

Group

A

B

C

D

[#2]

load *

<from table >

where Group <>'B';

[#3]

Thanks Surender

But I don't want to do that at script level. Do you have anyother suggestion other than doing at the script level.

[#4]

if you want to do it in the chart level u should use

if(Group <>'B',Area) as dimension. Also make sure u supress null values for this dimension on the chart.

[#5]

I already tried that but it is incorrect.

The code which you have given will exclude Group:B from all the Areas. Where as I want to exclude Group:B only from East(Area).

Its tricky right!!!

[#6]

Please use

if(Group <>'B' and Area <>'East' ,Area)

here the codition has to fullfill both the conditions and will produce the desired output.

Please do le me know if it helps

[#7]

Sorry Surender you are wrong again.

Area<>East will exlude East from the Area. Where as I don't want to do that.

I just want to Exclude Group B one and only from Group called East. In short A,C,D groups can be there in East but B should not be there in East(Only in East).

Very tricky isn't? I am also trying this from long time

[#8]

Pls send me the qv doc..

[#9]

Hi Surender

As requested attached you the doc. Hope it will be easy now for you.

[#10]

Hi,

The following expression should resolve the issue:

=IF(Area='East' AND Group='B',Null(),Group)

The document is also attached.

Cheers,

Haneesh