5 Replies Latest reply on Jul 29, 2018 3:53 PM by Cathy Ota

    Last term an ID was Offered

    Cathy Ota

      I need to show the last Term an ID was offered. Just a sample of the IDs and Terms. There are past and future terms in the View someone created. Both fields are varchar.

       

      IDTerm
      11176
      11178
      11184 (this term was the last term id1 was offered)
      21176
      21178
      21184 (this term was the last term id2 was offered)
      31176
      31178 (this term was the last term id3 was offered)
      41176 (this term was the last term and only term id4 was offered)

       

      Results needed

       

      ID117611781184
      11184
      21184
      31178
      41176

       

      Help is appreciated!