Rolling 12 Months Across YearsAugust 2 2012 at 2:56 PM
No score for this post
from IP address 188.8.131.52
Has anyone ever come up with a solution to do a rolling 12 months sum or average that crosses years where the period and years are in different dimensions? The only thing I have come up with was a dynamic calc where the subvars set the end point and save off history. Would need this to be more like DTS. I suppose a CDF is in order.
- Check out the @XRANGE function - Cameron Lackpour on Aug 2, 3:34 PM
- Thanks Cameron! - Edward on Aug 6, 1:58 PM
- Re: Rolling 12 months - Stuart Game on Aug 2, 6:04 PM
- Very Nice, Thanks Stuart - Edward on Aug 6, 1:58 PM