Cumulative Totals

PaulEveleigh — Wed, 22 Apr 2015 06:01:38 GMT

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

Re: Cumulative Totals

Sam_SAS — Wed, 22 Apr 2015 16:41:55 GMT

Hi Paul,

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

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