4 Replies Latest reply on Jan 7, 2019 7:05 AM by Manish Kothari

    How to have top 3 values from one column with filter on different column

    Manish Kothari

      below is the data available with me

      TypeNo.Quantity
      Labor10100011
      LaborDL100030125
      Labor44059300145
      Labor4488155037.5
      ItemW0001WEIGH4
      ItemE00001CAST4.5
      Item071115562C1
      Item1K0129620D5
      Item1K2819653B10

       

      The requirement is to have below output

         

      TypeNo.Quantity
      Labor44059300145
      LaborDL100030125
      Labor4488155037.5
      Item1K2819653B10
      Item1K0129620D5
      ItemE00001CAST4.5

       

      how to achieve this