1 Reply Latest reply on Sep 27, 2016 8:25 AM by David Li

    Previous Record

    Manigandan Arumugam

      My Table looks like below

       

       

      NOAction
      INooo1Resol70%
      INooo2Resp70%
      INooo2Resp100%
      INooo2Resol70%
      INooo2Resol100%
      INooo3Resp70%
      INooo3Resp100%
      INooo3Resol70%
      INooo3Resol100%

      I need to pick up the first record for Resp and also the first record for Resol. i tried creating calculated field but no luck.In some cases Resp70% is first record and in some cases we have resp 80% is first record. Please someone help.