Shortling Dimension

[snarrp_Rocky]

Need urgent help please.

How can I select only selected names in the dimension.

That is, I have below data, in that I need to select only Ram, Rakesh, Pooja and Ganesh.

NOTE: I need to achieve this from expression please not with script.

Ram
Rahul
Rakesh
Pooja
Mohan
Ganesh
Mahesh

Your name is greatly Appreciated.

Best Regards

[sergio0592]

Hi,

Try with :

if(match(Your_dim,'Ram','Rakesh','Pooja','Ganesh'),Your_dim)

[Vegar]

You can create a ListBox with an expression instead of an dimension like in the picture below.

[snarrp_Rocky]

##-actually I need to do this in straight table -##
Sent from Yahoo Mail on Android

[olivetwist]

See Attached

[stigchel]

As your dimension

=Aggr(Only({<FieldName={'Ram','Rakesh','Pooja','Ganesh'}>} Fieldname),FieldName)

[Brett_Bleess]

Please use the Accept as Solution button on any of the posts that helped solve your question, if you are still needing assistance, provide further details, and if you resolved it on your own, please share what you did and then mark that reply as the solution as well.

Regards,
Brett