I make trend analysis over sales.
Besides the actual sales figures, I would like to show a Moving Annual Total (MAT).
I can make this based on a specific period (using an offset of 0 to -11, and so on), but now I want to see the trend over an interval (for instance 12 month).
I am not able to incorporate the interval values into the period variable.
Can anybody help me with this?