condition dimnesion

[Anonymous]

hi,

i have pivot with dimension name "kodbreak",

i don't want to show kodbreak num - 1052,1058,1111.

i wrote at enabeld conditinal - kodbraek<> 1052,1058,1111

but nothing heppend.

what i did wrong ?

thanks'

yarin.

[priyav24]

Hi,

Try this,

=if(kodbreak<> 1052,1058,1111,

kodbreak)

in the calculated dimension

[Gysbert_Wassenaar · Accepted solution]

The conditional expression is for showing or hiding the entire dimension, not hiding some values but still showing the column. If you want to hide some values you have to use a calculated dimension:

if(match(kodbreak,1052,1058,1111), null(), kodbreak)

You'll also want to enable the Suppress When Values Is Null option of the calculated dimension.