04-02-2015 11:27 AM
Hi VA Experts,
Has anybody out there worked out how to do Moving Annual Totals in VA? I know there are lots of Out-of-the-box options like Year-to-date and Parallel Period Comparisons but I can't find a way to make the Periodic Operators sum up a value for a rolling 12 month Period. What I need to see is something like this ... where MAT is the running total for the previous 12 months...
04-03-2015 04:25 PM
I asked a developer who supports the periodic operators about this, and he doesn't know of a workaround in the current release. This feature is on our radar, so hopefully it can be implemented in a future release.