Show the highest cumulative value in the text box

[maohob1]

Hi everyone,

I have simple data like the one below .

TempData:
LOAD * INLINE [
MyDate , MyValue
03/01/2020 ,1
03/02/2020 ,3
03/02/2020 ,10
03/03/2020 ,25
03/04/2020 ,37
03/05/2020 ,-5
03/06/2020 ,3
03/07/2020 ,-9
];

I want to Calculation and display the highest cumulative value for the field "MyValue" .

using a text box object .

When calculating manually, it will appear that the number 76 is the highest number.
I want to show it in the text box.

Thanks 

[Saravanan_Desingh · Accepted solution]

Try this,

=Max(Aggr(RangeSum(Above(total Sum(MyValue),0,8)), MyDate))

[maohob1]

Thank you.