1 Reply Latest reply: Jul 1, 2013 11:53 AM by Sree Anarasi RSS

    12 months rolling growth rate



      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