47 Replies Latest reply: Feb 25, 2017 1:29 AM by Shivkumar Maurya RSS

    How to get value of top 2 vendors spend for a particular item

    Nagarjuna Vattikuti

      How to get value of top 2 vendors spend for a particular item.

       

      This is my sample data

       

       

        

      Item ID Vendoe name Spend 
      5112Vendor 1 3,000.00
      5112Vendor 2 20,000.00
      5112Vendor 3 25,000.00
      6113Vendor 1 34,560.00
      7889Vendor 1 56,000.00
      9887Vendor 1 670,000.00
      6113Vendor 2 34,520.00
      9887Vendor 2 120,000.00
      7889Vendor 2 3,000.00
      5112Vendor 4 75,000.00
      7889Vendor 3 10,000.00
      9887Vendor 3 14,000.00
      6113Vendor 3 98,760.00
      3456Vendor 1 34,560.00
      6113Vendor 4 100,000.00
      7889Vendor 4 2,000.00
      4562Vendor 1 456,890.00
      6113Vendor 5 2,000.00
      5112Vendor 5 60,000.00
      3452Vendor 1 23,480.00
      9870Vendor 1 18,000.00
      9870Vendor 2 26,000.00
      3452Vendor 2 35,000.00
      6113Vendor 6 5,000.00
      9887Vendor 4 12,556.00

       

      Here i want to get total spend of top 2 vendors based on spend (i.e vendor 4 and vendor 3) for  an item ID 6113. I don't want to write 6113 in formula, it should be automatic, it is 3rd item based on total spend.