I have 10,000 customers and have been trying (for some time) to calculate a ranking based on how long each customer has been with the business.
Calculating the top 10% is easy but does anyone have any idea how to calculate those customers that are between 11% - 20%, 21% -30% and so on?
PS … I need to be able to do this ‘on the fly’
asked Aug 03 '12 at 08:28 PM in Default
If your group percentages are set try this:
answered Aug 21 '12 at 04:12 AM
Scot / Fatherjack, Thanks for the samples ... in the end I took somewhat of a shortcut.
I created a query on the customer file using RANK. Then wrote a module to allow the user to set whatever levels they want and run a table update.
Thanks for the help.
answered Aug 27 '12 at 01:35 AM