1 Reply Latest reply: Jul 27, 2014 3:28 AM by Enrique Colomer RSS

    Computing Linest_M

    Lawrence Chen

      Hello,

       

      Attached is my solution for calculating the trend (slope) of business departments' sales revenue over a 6 months window.  I like you to review my expression to make sure that (1) it is written correctly for the intent and (2) if there is a more efficient or more straight forward way of forming the aggregation / calculation. Thank you.

       

      The data dimensions are as follow:

       

      Business Unit = department

      Client Number and Sub Analysis = customer and product

      RevenueDate = sales date

      #RevenueUSD = sales amount

       

      The task is to calculate the revenue trend of each business unit over the set period.