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

[SonaliSahoo]

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 .

[MarkusWeick]

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

[SonaliSahoo]

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  ). 

[SonaliSahoo]

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..

[MarkusWeick]

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