You can try to use sumOver()
sumOver()
Create a new calculated field (eg Sum of Max Order Amounts).
Use below formula to sum the maximum values
sumOver({order_amount}, [{At ID}])