top 100 of smallest amount

[#1]

Hi guys!

I want to creat a table where it shows top 100 invoices with the smallest amount (but greater than 0).

Please help!

thank you!

//A.

[#2]

I need top 1000...

[#3]

Here would be my solution:

=IF(rank(IF(Amount>0,-Amount))<1000,Amount)

I don't know if you have to deal with sum of Amount.

[Anonymous]

What if you just create a table without the 0-amounts,

Sort them on smallest amount first

Then set Max Number to 100 (presentation tab)