search for least sold products

[stolen_gtr]

hi all,

i was wondering if there was a way to write a script to display the least sold products in my database. i have a field which calculates how many times each product has been sold, and currently i am doing a find to display products sold < 10 times. I know this is not a very good way of doing it because it doesn't show the 5 least sold, just ones sold under 10 times. I hope there is a script which will allow me to achieve this.

thanks in advance,

Lucas

[comment]

How about:

Show All Records

Sort [ by quantity sold, ascending ]

Go to Record 6

Omit Multiple Records [ Get ( FoundCount ) - 5 ]

Could be made a little smarter by adding a loop in case there's a tie for 5th place.