how to hide specific values in a dimension?

[chriscools]

Hello,

i have a table with 1 dimension and a few expressions.

the dimension has 5 different values, but i would only to show 3 of them.

do i make a calculated dimension for this? and how would i then exclude the 2 values i don't want?

thanx!

chris

[sivarajs · Accepted solution]

Create calculated dimension like

if( not wildmatch(Dimension,'*Val1*','*Val2*'),Dimension)

or

if(Dimension<>'Val1' or Dimension<>'Val2',Dimension)

[chriscools]

Hello,

the first solution worked, but the second dit not .

(there the values for the dimension got a different sorting, but nothing else happened)

thanx!

chris