• This would be my ideal ranking. Using the 2008 year as an example

    Select 6,1028,'High' union all

    Select 2,924,'High' union all

    Select 3,862,'Medium' union all

    Select 4,724,'Medium' union all

    Select 5,628,'Medium' union all

    Select 1,569,'Low' union all

    Select 7,488,'Low' union all

    Select 8,321,'Low' union all

    Select 9,284,'Low' union all

    Select 10,161,'Low'

    In this case it breaks down to 32.5% high, 36.9% medium, 30.4% low.

    You will have to forgive me, but if you have 2 rankings of 'High' in a set of 10, how does that equal 32.5%? My maths says that is equal to 20% (2 rows / 10 total rows).

    The NTILE example I gave you is grouping by sales.