Eliminating field value

[#1]

I have a field called region with different region names.In regions I have Atlanta,Floroda,washington etc.I dont want to display Atlanta in that Region list box.How can I do this ?Please help me.

Thanks in advance.

[#2]

On the general tab of List Box Properties, select <Expression> in the field drop down. Use this expression to exclude Atlanta (assuming your field is named "Region"):

=if(Region='Atlanta',null(),Region)

[MayilVahanan]

Hi

Try like this

In expression

=if(Region<>'Atlanta',Region)

[tresesco]

Try expression for the list box, expression:

=If(Region<>'Atlanta', Region)

[nizamsha]

=if(Region<>'Atlanta',Region)

[#6]

Or you can put that limitation on you expression with SetAnalysis.

Sum({$<Region={'Atlanta'}>}[Region Sales])