Set analysis help needed?

[siva_boggarapu]

Hello Everyone,

Let say I have one list box which is containng number of Values like below

FIELD

AAA

BBB

CCC

DDD

EEE

FFF

GGG

HHH

III

JJJ

KKK

LLL

MMM

NNN

:

Here, my question is how can i show only 'AAA','BBB','CCC' values only using set analysis. Rest of values should not visible.

Best,

Siva.

[swuehl · Accepted solution]

Select  <expression> from the field list drop down in the list box properties and try something like

=aggr(only({<FIELD={AAA,BBB,CCC}>} FIELD),FIELD)