How to get a value in the list which will select all values in the list

[aniketsr]

Hi ,

I have a requirement which states as follows:

I have a List box for region and the values in the list box are (NAM,EMEA,APAC,LATAM)

now my requirement is that i want one more value in the list which will select all the region in the list box and the name of the value shall be ALL.

Any help with this regards will be appreciated

Thank you in advance.

[Chanty4u]

am not sure

create a inline table with the region vlaues with all

load *Inline [

region,All

];

[Kushal_Chawda · Accepted solution]

Region:

Load distinct Region, Region as REGION

Resident DATA;

Concatenate (Region)

load Region, 'ALL' as REGION

resident Region ;

Now use REGION as your selection

[techvarun]

All in the list/Multi box