Max value in Set analyse ...

[jozisvk11]

Sum({< [Account] = {'326100'}, [Type] = {'5'} , Max(Rank of the row)>}Round([Sum of money],0.01))), 0.01)

At first, I have table :

ID             Rank of the row            Type                Sum of money

K01                 1                              5                         100

K01                 2                              5                         200

K01                 3                              5                         700

K02                 1                              5                         300

K03                 1                              5                         500

K04                 1                              5                         550

K04                 2                              5                         650

...

I need filter according to Max(Rank of the row) But max function don´t run.

My result should be :

ID             Rank of the row            Type                Sum of money

K01                 3                              5                         700

K02                 1                              5                         300

K03                 1                              5                         500

K04                 2                              5                         650

Thanks for helping.

[Kushal_Chawda]

Our job is to give options, that is what we are doing. But we should not try it when Stefan has already replied because his solution is always optmimal

[sunny_talwar]

Well I wouldn't stop trying. Unless we won't try, we won't improve. We should all try to be better than Stefan one day . Its a different matter if we will reach to that level

[Kushal_Chawda]

You are correct. tune aankhe khol di meri.

[jozisvk11]

Thanks a lot for helping me.