Hey Guys,
Can anyone help us on how we can do the sum aggregation in Hana XSA?
We need to do the below calculation in XSA. The below screenshot is from SAC.

We tried implementing the same in SAP AFO but we have seen many options are disabled for Hana Reports as group by on a single column is also not possible. We are able to see only Rank Number and Olympic Rank Number option enabled.
Can anyone please guide us on the same? If the above calculation is possible in AFO also please guide.