4 Replies Latest reply: Jun 14, 2018 1:09 AM by Shivesh Singh RSS

    Add new values to an existing field

    Snehasis Patnaik

      Dear Community -

       

      I have a field called ASG which has Values - (CR, CAG, LC, ME).

      I want to add one more Value to it in the script Called 'THT' which will mean all those activities where AST = 'HT'.

      So finally I'll have 5 Values in it.

       

      The purpose is to show - Count (activity IDs) by ASGs in  straight table

       

      Here's My Data sample -

         

      Activity IDASGAST
      1CRHT
      2CAGCA
      3LCHT
      4MEHT
      5CAGCA
      6CAGCA
      7MEHT
      8CRHT
      9LCHT
      10CAGCA

       

      And this is how I want to create my Straight table -

       

         

      ASGCount
      CAG4
      CR2
      LC2
      ME2
      THT6

       

      Can anybody help me here?

       

      Thanks in advance!