Dimension expression help

[#1]

I am trying to write an expression for the below Associate dimension that will display all agents except the agents that work for Simon who do not reside in Florida.  If an associate works for another manager then I do not care where they live.  Below in red is an example of the results that I am trying to produce:

Thanks in advance!

Manager	Associate	State	Production
Simon	Jan Harlow	LA	$300
Bob	Frank Smith	CA	$2800
Joe	Dan Ly	TX	$250
Simon	Bill Allen	FL	$700
Joe	James Mint	NV	$1200
Simon	Donna Spelding	FL	$800

If

[m_woolf]

=if(not(Manager='Simon' and State <> 'FL'),Associate)

[#3]

Hi,

=if(Manager<>'Simon' and State <> 'LA',Associate)

Rebeca

[jpapador]

If Production is a expression.  Use a straight table and make your expression

Sum({$<Manager-={'Simon'}, State-={'<>FL'}>}Production)

[#5]

This is helpful but the expression isnt removing the associates who work for Simon that do not live in FL.

[#6]

Hi! Thanks for your response but I tried this expression and it removes all of Simon's associates.  I just want to remove the ones who work for Simon that do not work in FL. Thanks again!