| Rolling 12 Months Across YearsAugust 2 2012 at 2:56 PM No score for this post | Edward from IP address 216.58.241.102 | |
| 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. |
| Responses- 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
|
|
|