Running Total Year over Year

user06209
user06209 βšͺ️

Hello,

Is there a way to do a running total year over year inside analyzer or do I have to go into ETL and manipulate the data in order to have a year over year?

When using the running total graph, I tried to change my X-Axis by month and Series by year but it made my current year the same value for future months but my previous year was correct.

Answers

  • GrantSmith
    GrantSmith Indiana 🟀

    Hi @user06209

    You can utilize window functions in a beast mode (you just need to have them enabled - talk to your CSM)

    SUM(SUM(`Amount`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`)
    
Sign In or Register to comment.