Sum of all largest values

[dzmitry_shmurye]

Hi community!

I have a small table:

The first expresion is the simple sum.

I want get the second expresion with sum of the all values in the table but only values wich are largest than current string.

For example for Prod2 Sum 10+15+20 = 45 (all values >5, but not include 1)

Could somebody help me with this expresion?

Thanks!

[sunny_talwar]

Great... I am glad you are playing around with the expression to make it better ... 

[sunny_talwar]

The only issue is that you can sort by Amount as long as its not aggregated, but if you won't be able to sort by Sum(Amount). That is something to keep in mind

I suggest marking some helpful answer so that it can be useful for people in the future to look for helpful answers in the thread.

Best,

Sunny