Cummulative by creating aggregated measure

[ashishj816]

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,

[TedStolarczyk]

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