7 Replies Latest reply on Sep 1, 2018 10:17 AM by Shinichiro Murakami

    Sorting Measure Values by string

    Juan Medel

      I have my Measure Values named "Text1 Text2". I'd like to sort them by the Text2 part of the string and ideally make groups, get totals of the groups and so on. Would it be possible?

       

      Example:

       

      Db G1

      Db G2

      Db G3

      Xl  G1

      Xl  G2

      Xl  G3

       

      Into

       

      Group1      Db G1

                        Xl  G1

      Group2      Db G2

                        Xl  G2

      ...