7 Replies Latest reply: Mar 4, 2015 7:02 AM by amir ohev shalom RSS

    Dimension with case

    amir ohev shalom

      Hello all,

       

      I want to built dimension with sum of expression.
      For example:

      i have table like this

      Month number count

      --------- --------- ----------

      jan      22222    100

      jan      22222     205

      jan      33333     150

      feb      22222     50

      feb      33333     100

      feb      33333      50  

      and i want to add dimension  (type) that wiil show me -  if(sum(count)>'300','big','small')

      Month number count  type

      --------- --------- ----------  -------

      jan      22222     305     big

      jan      33333     150   small

      feb      22222     50     small

      feb      33333     150   small

       

      if i add expression with this case i get blank field.

       

      thanks in advaned

      Amir