1 Reply Latest reply on Dec 5, 2018 8:55 PM by Zhouyi Zhang

    Merging Values in a table

    Joseph Ong

      Hi all, I would like to seek help here:

       

      I have a data table as such:

         

      StaffSchemeStatus
      JohnAStudying
      LisaAStudying
      MaryBStudying
      PeterBStudying
      LilianBStudying

       

      By the usual drag and drop method I am able to display the data summary as such:

        

      Studying
      Scheme A2
      Scheme B3

       

      Question is, is there any way I can merge the values and rename the labels as such?

       

         

      Studying AStudying B
      Scheme (A&B)23

       

      Many thanks