Overlapping labels in an Oracle APEX pie chart

Ever had the problem of overlapping labels in a pie chart which you used in an Oracle Application Express (APEX) application? Have a look at Gary Myers excellent tip to avoid collisions by using analytic functions to sort the data. It's another great example of using the built-in power of the Oracle database.