8 Replies Latest reply: Feb 9, 2016 11:02 AM by Harshit Bhatia RSS

    Group by dimension

    Mark Graham

      Hi all,

       

      I was struck at a basic 'if expression' which should separate the Categories based on ID and Name.

       

       

      ID,    Name,Type
      abcd,123,A
      abcd,456,B
      efgh,789,A
      ijkl,       1011,    B
      mnop,1213,A
      qrst,1415,B

       

      Here i want to create two new fields ID Category and Name Category which will differentiate it's own types - A and B.

       

      any help is highly appreciated.

      Please find the attachment.