Table ordering help

[Antuan Johnson]

I'm a developer of chart game and I need help with formulating a way to show
charts. I need to sort the data in the table by the column(Sales) of the
table descending and then by using that I have to somehow generate new ids
that show their new position, and then put them in their own column (Chart
Position)

Any ideas about how this can achieved with Valentina or an alternative that
would work equally as well?

Current Table
Sales, Chart Position
500,0
300,0
100,0
900,0

What I need accomplished
Sales, Chart Position
900,1
500,2
300,3
100,4



--
Lead Developer of MWR,
Wolverine Studios
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090206/95a7483d/attachment.html