9 Replies Latest reply on Aug 25, 2018 8:41 AM by Mahfooj Khan

    Need to find max quarter's value where the quarter column is string datatype

    Ajith Suresh

      I have a requirement where we need to find the data for MAX(Year-Quarter) where  Year-Quarter is string column. Some how i need to find the data for maximum Year-Quarter's data, with respect to this also i need to find the respective MOM and YOY for corresponding Year-Quarter.

       

      Could anyone of you suggest a solution for this.

       

      PFB screenshot for Year-Quarter column data:

       

      Please let me know if need additional informations.

       

       

      Thanks in Advance,

      Ajith V S.