1 Reply Latest reply: Jul 1, 2013 11:53 AM by sree anaarasi RSS

    12 months rolling growth rate

      Hello,

       

      I am trying to build the following expression:

      - depending on date selection the application would return sum of SALES from last 12 months AND from 12 months a year ago. This would enable me to calculate rolling YtY growth rate afterwards. 

       

      My calendar column structure looks like this:

       

      1. data - MM/DD/YYYY

      2. Year - YYYY

      3. month - oct, sept, etc.

      4. day - DD

      5. Quarter - Q1, Q2 etc

      6. month year - oct YYYY, sept YYYY etc

       

      Any ideas how to the expression should look like?

      Thank you in advance

      Przemek