9 Replies Latest reply on Feb 1, 2017 9:44 AM by Rahul Patil

    String as a Measure

    Nivedha Satyamoorthi

      Dear All,

       

      Is there a way to make a string as a Measure? I have two measure fields A, B which can have values 0,1 or 2. Is the value is 0, I have to populate the cross tab as "NULL", 1--> "SOME", 2-->"ALL".

      I tried to convert it to String and make Alias, but the field does not come under Measures but works only as Dimension.

       

      From:

              

      SessionAB
      510
      621
      TO:
      Sessionab
      5SomeNULL
      6ALLSome