9 Replies Latest reply: Feb 28, 2018 1:35 AM by vidya sagar malla RSS

    Calculate TOP 2 Companies

    vidya sagar malla

      Hi,

       

      With the below table. I want to calculate top 2 companies base on the sum of sales. Can some please help me with the logic.

       

      YearCompanyAmount
      2010Apple10
      2010Nokia20
      2010Samsung30
      2010Apple100
      2010Nokia200
      2010Apple500
      2011Nokia100
      2011Samsung200
      2012Apple500
      2012Nokia150
      2014Apple600
      2014Nokia100
      2014Samsung150
      2014Apple300
      2014Nokia200

      Thanks,

      -Vidya