0

Dynamic Cumulative calculation

HI,

Is there any way to do cumulative calculation Dynamically without using Lookup or Spark SQL. 

Lookup method works if data is Year and Quarter level as it is row based Operation

Spark SQL method work but data is persisted 

Example shown below

Year Quarter Amount Cumulative Amount
2018 Q1 10 10
2018 Q2 20 30
2018 Q3 30 60
2018 Q4 55 115
Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 mths agoLast active
  • 15Views
  • 1 Following