Max at one level and sum at another

I want to have the max of a value at a level and then sum at levels above,
I’m using the following:

However the result I’m getting is a sum at all levels instead of having a max at the first and then a sum

I also checked, if I replace the max with min or sum I get the same value

I think you need to take the maxOver before you take sumOver.


Let me know if that works

Hi, @Carl_Chahine. We hope that Max’s solution worked for you. I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks!