5 Replies Latest reply: May 22, 2013 11:24 AM by Robyn Talley RSS

    Dimension expression help

      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!

       

      ManagerAssociateStateProduction
      SimonJan HarlowLA$300
      BobFrank SmithCA$2800
      JoeDan LyTX$250
      SimonBill AllenFL$700
      JoeJames MintNV$1200
      SimonDonna SpeldingFL$800

       

      If