5 Replies Latest reply: Feb 3, 2014 8:05 AM by Aqeel Nawaz RSS

    First Row of the Group

      Dear All

       

      I have a data in below mentioned format.

       

      I just want to to display on first row of each group.

      First row of each group should be the row having least Mfg_Date of the group.

       

      Grouping is based on Product ID.

       

      Kindly suggest.

       

      Product IDNameBatch #Mfg DateQty
      1ABC1231-Jan-14232
      1ABC45610-Jan-14433
      1ABC23415-Jan-1454
      2XYZ342-Jan-1476
      2XYZ4325-Jan-1454
      2XYZ435431-Jan-14545
      2XYZ45341-Feb-14544
      3QWE423410-Jan-14454
      3QWE645625-Jan-14657
      4ASD86711-Jan-1454
      4ASD5412-Jan-145453
      4ASD53425-Jan-14342
      4ASD65429-Jan-14323
      4ASD64562-Feb-14342
      5ZXC53455-Jan-14534
      5ZXC423410-Jan-144534
      5ZXC43215-Jan-14534
      5ZXC545416-Jan-142342
      5ZXC656525-Jan-1456
      5ZXC876862-Feb-14676

       

      Thanks & Regards

      Aqeel Nawaz