find max value on using when using range sum function.

[#1]

I am using function rangesum in straight table and output is accumulate value,now i want to apply max function on this and find max value according to dimension.

in above screen shot field AccumulateAmount is created from formula "Rangesum(Amount,above(AccumulateAmount)))".

now i want to find out only max value of this field basis on Name .

need output as given below in same  qlikview.

ex.

Application also Attached.

Please Suggest what can i do to find max value.

[swuehl · Accepted solution]

Have you tried dimension Name and as expression

=Sum(Amount)

?

Should have opened your QVW, try

=Sum(Aggr(FirstSortedValue(Balance,-Date),Name,Account))

Name	Sum(Aggr(FirstSortedValue(Balance,-Date),Name,Account))
	72395
Mohit	10000
Ramesh	47829
Rohit	14566

[#3]

Thanks swuehl now it is woking.