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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 1108 views
  • 3 likes
  • 2 in conversation