Maybe this can show the percentages better.

High 1952

% Of Total High 32.593

Medium 2214

% Of Total Medium 36.9677

Low 1823

% Of Total Low 30.4391

Total 5989

Select

Sum([High]) As High

,Sum(High)/ (Sum(High) + Sum(Medium) + Sum(Low)) * 100 As [% Of Total High]

,Sum([Medium]) As Medium

,Sum(Medium)/ (Sum(High) + Sum(Medium) + Sum(Low)) * 100 As [% Of Total High]

,Sum([Low]) As Low

,Sum(Low)/ (Sum(High) + Sum(Medium) + Sum(Low)) * 100 As [% Of Total High]

,(Sum(High) + Sum(Medium) + Sum(Low)) As [Total]

From

(

Select 6 As house_ID,Cast(1028 As Decimal(18,2)) As [2008],'High' As [Rank] 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'

)A

Pivot

(Sum([2008])

For Rank in ([High],[Medium],[Low]))B