How to do the total or sub total in RAP custom query

[kunal_chandra]

I have a requirement which I have developed using RAP custom query. It has just 10 fields including one currency field.Report is working fine. Now I got an additional requirement to show total or subtotal based on currency field. I tried annotation @default aggregation #sum but it is dumping and I also tried UI.presentationvariant: total,GroupBy but it is not working .

Please suggest how to achieve this in RAP custom Query.

Regards,

Kunal

ABAP RESTful Application Programming Model 

[rammel_sapdev]

Hi,

Have you found a solution for this? I saw this from the documentation https://help.sap.com/docs/abap-cloud/abap-rap/annotating-aggregate-functions-in-cds but it was not working for me when using unmanaged query. We have a similar requirement to have a subtotal and wondering if it is possible.