4 Replies Latest reply on Apr 2, 2016 10:28 AM by Dany Krivoshey

    Ranking sales across the years by the sales of last year only

    Dany Krivoshey

      Dears

       

      Have two years of Data.

      Need to present Data by ranking sales of both year by sales of 2016 only, see example below.

      Trying to do it via index() however getting ranking for sum of two years (Total Sales).

      Attaching the working file.

      Please advice.

       

      Thank you, Dany

       

      Data 

      YearBrandSales
      2015A100
      2015B200
      2015C50
      2015D300
      2015E80
      2015F40
      2015G100
      2015H150
      2016A80
      2016B220
      2016C50
      2016D200
      2016E300
      2016F400
      2016G20
      2016H80

       

      Presentations Required

      BrandRank by 2016 sales20162015
      F140040
      E230080
      B3220200
      D4200300
      A580100
      H680150
      C75050
      G820100