BookmarkSubscribeRSS Feed
dlyons
Calcite | Level 5

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

MonthValueYTDMAT
Apr-15£100£466£1,334
Mar-15£123£366£1,345
Feb-15£145£243£1,314
Jan-15£98£98£1,257
Dec-14£99£1,237£1,237
Nov-14£78£1,138£1,233
Oct-14£90£1,060£1,248
Sep-14£145£970£1,249
Aug-14£120£825£1,194
Jul-14£87£705£1,163
Jun-14£97£618£1,163
May-14£152£521£1,151
Apr-14£111£369£1,083
Mar-14£92£258£1,055
Feb-14£88£166£1,044
Jan-14£78£78£1,035
Dec-13£95£1,035£1,035
Nov-13£93£941£941
Oct-13£92£848£848
Sep-13£90£756£756
Aug-13£89£666£666
Jul-13£87£578£578
Jun-13£86£491£491
May-13£84£405£405
Apr-13£83£321£321
Mar-13£81£239£239
Feb-13£80£158£158
Jan-13£78£78£78
2 REPLIES 2
Sam_SAS
SAS Employee

HI dlyons,

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.

Sam

dlyons
Calcite | Level 5

Thanks Sam.  I'll keep an eye out for it in future releases.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1213 views
  • 3 likes
  • 2 in conversation