restricting the no of records in drop down listbox in straight table

[nizamsha]

Hi

can any one can guide me

i have 5 field say

name,

number,

address,

city,

country,

its a straight table

i displayed drop down listbox to all the five field

but my question is in city field i have four record say a,b,c,d

i wnt to display only 3 record  in my drop down listbox how can i do .please guide me

[sivarajs]

write expression as if(city<>'d',city) in your  dimenion

[sushil353]

Instead of taking field in listbox...

take expression and write the code as suggested by sivaraj.

if(city<>'d',city)

HTH

Sushil

[nizamsha · Accepted solution]

=aggr(only({<yStatus={'Won','Lost'}>}yStatus), yStatus

we should use calculated dimension and  also oly function