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

Cumulative Totals

Reply
New Contributor
Posts: 3

Cumulative Totals

Hi there,

I am brand new to SAS VA so apologies if my question is overly simple.

I am trying to produce a graph that shows cumulative sales during a month (by day) compared to the same month last year. (As per image below).

I can't seem to work out how to do this - would appreciate some assistance.

Kind Regards

Paul

Cumulative Sales.bmp

SAS Super FREQ
Posts: 296

Re: Cumulative Totals

Hi Paul,

The CumulativePeriod operator in an aggregated measure is what you would use to perform this type of task.

https://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n1lxnqfip132can1hdzu...

Unfortunately, you cannot display cumulative values by day for a year other than the current year.

You can compare cumulative values by month (or by quarter) to the previous year (or quarter).

You can display cumulative values by day for the current year, month, quarter.

It is conceivable there's some workaround I'm not aware of.

Thanks,

Sam

Ask a Question
Discussion stats
  • 1 reply
  • 342 views
  • 0 likes
  • 2 in conversation