Summarize values in list

[fred_s]

Hi,

Is there a way to quickly select Customers with a total amount between 25000 and 50000, where Total amount is something like "sum(Ordervalue)"?

Is there a way to create Ranges and put these ranges in a List where People can select them, say:

A > 50000
B > 25000
C > 10000
D <= 10000

Thanks in advance!

[alexandros17]

Look at the function "RANK" it solves your problem and you can use it as expression in a list box

Hope it heklps