Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Need help for doing Column Cumulative in VA 6.4

Reply
Contributor
Posts: 29

Need help for doing Column Cumulative in VA 6.4

Can anyone explain me how to do column cumulative in VA 6.4.Thanks in advance..

Regular Contributor
Posts: 172

Re: Need help for doing Column Cumulative in VA 6.4

Dear avinesh...

If all of your data is related to a real date and can be reported in calendar month/days etc you can use the standard YearToDate function

First created a cross table with the month and dayOfMonth related to the transaction Date.  (Just an example)

Formula3.png

Then go to the Kg field in the data tab and right click the mouse for the options to select Create and YearToDate Using Date.  (The transaction date)

Formula4.png

Just drag in the new variable and thats it.

Formula5.png

This is from SAS VA 6.3, but I am sure its must be almost the same.

Greetings and good luck.

Contributor
Posts: 29

Re: Need help for doing Column Cumulative in VA 6.4

Hi PeterWijers

Thanks for your reply.But My client looking a column cumulative answer like a snapshot which i am annexing here.demo.png

Regular Contributor
Posts: 172

Re: Need help for doing Column Cumulative in VA 6.4

Hi avinesh,

Just a quick question.

Is the data already on month level cumulated or is the data below still on date level.

greetings

Contributor
Posts: 29

Re: Need help for doing Column Cumulative in VA 6.4

Hi peterwijers,

still it is in date level only...

Regular Contributor
Posts: 172

Re: Need help for doing Column Cumulative in VA 6.4

Hi, Avinesh,

Than it works the same way, but only you have to define a copied item of the Date to Month format.

Sadly I see that if you put year in front of the month, the calculations reset for every year. (I have no idea how to solve this within VA)

Formula6.png

So I have no direct solution for the cumulation over the years.  (Maybe someone else has a good idea how to solve this)

Anyway good luck.

Greetings

Post a Question
Discussion Stats
  • 5 replies
  • 504 views
  • 1 like
  • 2 in conversation