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

Cummulative by creating aggregated measure

Reply
Occasional Contributor
Posts: 14

Cummulative by creating aggregated measure

Hi,

 

I am trying to create cummulative of opening balance which should change according to month but it is not happening and for all other months other than Jan value comming as 0,however in excel when we filter the data values are comming as required.I am attaching few screen shot and excel please find attachment.

 

Thanks,


Cum_ob.pngob.png
SAS Employee
Posts: 35

Re: Cummulative by creating aggregated measure

ashishj816:

 

If you're doing what I think you're trying to do, I can't seem to duplicate.

See my attached screen captures.

 

1 long shot idea is that I notice you have a Section prompt for Month.

Which I would think would filter/limit all the visualizations and what they do on that screen to just 1 month.

 

Otherwise, if you think the software is not doing what you think it should do, perhaps at this point if you could call this into SAS Tech Support, so they can futher troubleshoot for you.

 

Sincerely,

Ted Stolarcyk, SAS Customer Loyalty team

 


CrosstabResults_Of_AggrFormula.pngCumulative_Formula_I_Used.pngListTableResults_Of_AggrFormula.png
Ask a Question
Discussion stats
  • 1 reply
  • 347 views
  • 0 likes
  • 2 in conversation