Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

abap cds - aggregation, Is it possible to calculate the current row as the previous row?

hongjonghwa
Discoverer

‎2023 Mar 18 4:49 AM

0 Kudos
319

hello?

I need the previous record value because I need to aggregate and sum up the month data of the current year according to a condition and compare it with the month data of the previous year. Is this possible with cds aggregation?

please help me!

1 REPLY 1

Sandra_Rossi
Active Contributor

‎2023 Mar 18 9:34 AM

254

I guess you want to extract these columns:

  • year
  • month
  • total amount

group by year and month

and condition is to select previous year and current year

so I don't see any problem