Display only a few Dimension members

[#1]

Hello

I have a Dimension and I would like to display only a few member for selection.

I am trying something like:

=if(Dimension = {'Yes','No'},Dimension)

But seems not to work

Any suggestions??

thanks

[MayilVahanan · Accepted solution]

HI

Try like this

=if(match(Dimension,'Yes','No'),Dimension)

or

if(Dimension = 'Yes' or Dimension='No', Dimension)

Hope that helps