topic Re: Year to date cumulative value comparison current year vs previous year in visual analytics in SAS Visual Analytics

Year to date cumulative value comparison current year vs previous year in visual analytics

SonaliSahoo — Mon, 14 Nov 2022 10:16:22 GMT

i want cumulative revenue comparison between two financial year with respect to a particular month & day

for example - cumulative sum of revenue for financial year 2020-21 (till October 2oth )

with financial year 2021-22 (till October 2oth )

Note : Year starts from 1st of April ends with 31march .

Re: Year to date cumulative value comparison current year vs previous year in visual analytics

MarkusWeick — Mon, 14 Nov 2022 10:30:42 GMT

Hi @SonaliSahoo ,

here (SAS Visual Analytics Advanced Calculations (part 1... - SAS Support Communities) you can find a very good treatment of your question (series of 4 posts).

Best

Markus

Re: Year to date cumulative value comparison current year vs previous year in visual analytics

SonaliSahoo — Mon, 14 Nov 2022 13:35:27 GMT

Dear @MarkusWeick

Thanks for the suggested blog.

But still i am not able to achieve my required goal.

To be more specific , i need year to date cumulative sum comparison (starting from 1st of April to any date i can put in my wish , which can be applied for any two financial years ).

Re: Year to date cumulative value comparison current year vs previous year in visual analytics

SonaliSahoo — Mon, 14 Nov 2022 13:36:53 GMT

Can We get in to a call , if you are available.

Any schedule will be fine for me (24/7).

Do let me know , if possible..

Re: Year to date cumulative value comparison current year vs previous year in visual analytics

MarkusWeick — Mon, 14 Nov 2022 19:31:53 GMT

Hi @SonaliSahoo,

I would need to prepare an example before a call. But at the moment I don't have access to my VA installation.

Sorry:

Best

Markus