0 Replies Latest reply: Jun 13, 2015 3:04 PM by surfman joe RSS

    to find out the fastest growing/declining items

    surfman joe

      I am facing a request to find out the fastest growing/declining items in sales in past X period where an end user could pick up from a time list box. Let us say, last 12 weeks. I have weekly sales per item per store on hand, total around 10000 items, 100 stores. relatively a big sheet.

       

      I am lost in constructing the expression. It looks need compare each item with each other by weekly sales per store in same period. Can anyone could shed some light? Many thanks.