You might also consider how simplistic the ranking system is.

A more meaningful ranking might be to get the total $ sales of all customers,
then into the ranking field put what percentage of that is this particular
customer's sales.

I have done reports in which the customer data is sorted from high $ going on
down, and then we only print the first couple pages.  If done via RPG, you
can have the program track how often new page is tripped & then end the
program execution after a selected number of pages, so you don't eat 400
resource generating the part of the report we are not going to need. (Alister Wm Macintyre) (Al Mac)

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.