5 Replies Latest reply: Nov 6, 2015 8:22 AM by Liron Baram RSS

    How to first rank items then find the week on week sales of the items?

    Eng Xiong Lim

      Hi everyone, I am trying to create a table that first rank the brands (top 5) by sales volume, grouped by product category. Then, for each of the top 5 brands, find the week on week sales performance.

       

      Product Cat.

      Brand RankBrandSalesSales LWDelta
      X1ABC$1200$100020%
      2DEF$500$1000-50%
      3FG$1000100%
      4HH$50$25200%
      5IJ$10$100%
      Y1AA$500$100500%
      2BB$300$600-50%
      3CC$200$100100%
      4

      DD

      $150$1000-85%
      5EE$100$200-50%
      Z1
      2

       

      Any possible solution is welcomed. Thanks in advance.


      Cheers,

      Eng Xiong