Aggregation fields in the analytical query sum up in the wrong way

[Expert]

Hi everyone,  We have created a custom CDS View and build an analytical query based on this CDS View.  Here is our problem:  If there is only one aggregation field, such as "SUM" quantity, then the result can be split by the dimensions correctly.    But once there are more than 2 aggregation fields, then the result is wrong.    Could you help us with it?  Thank you!  Ria

[Expert · Accepted solution]

Hi Ria,

Could you please check this blog and see if it helps you:

https://s4hanacloud.community.sap/blogs/show/j2oqOIgQz6rvQ6yD7wVLaq

Best Regards,

Varun

[Expert]

This is a re-posted Q&A of an earlier question on this community