3 Replies Latest reply: Apr 25, 2014 5:00 AM by Manish Kachhia RSS

    static vs dynamic count

      Dear All,



      How if we want to count dynamic expression ?

      I would like to "identify" city that has sales more than variable numbers, let say : if sales more than 150, i would like to color it red ( we can do it in tab visual cues properties )

      So, after i did some setting in visual cue tab, the city new york, miami are getting red.

      How if i collapse the country dimension ? how if i want to put "2" to the dynamic expression column ? ( the dynamic expression column for england will become 0, and will become 1 if the variable-parameter changed from 150 to 100, etc )


      the "150" ( threshold of sales ) is a variable parameter...

      any suggestion ?


      thx in advance

      ( sorry for my bad english-typing )


      country ( dimension )
      dynamic expression
      New York200