removing member from dimension

[#1]

Hi

How can i not show a member in dimension, so in the example below i do not want to show 2.

1

2

3

4

[#2]

Hi

In the above example, if i dont want to show 2 and 3 how would i extend this?

[salto]

Hi,

what about adding an "or" condition to the calculated dimension...

=if(field<>2 or field<>3,field)

[#4]

the or statement left them both in so used the and and that worked.

thanks

[its_anandrjs]

Hi,

You can write also

=if(not Match(field,2,3),field)

Regards

Anand

[salto]

Oops, my fault I wrote too fast!