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 )
      city
      sales
      dynamic expression
      USAWashington100
      New York200
      Miami250
      EnglandBristol80
      Cambridge75
      Manchester125