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:
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