Hey Thanks Jeffery ...:-):-)

I just used unpivot in the query you provided and got it the way I wanted in one column....Thanks again:-)

Declare @curYearStart datetime

,@prevYearStart datetime;

Set @curYearStart = dateadd(year, datediff(year, 0, getdate()), 0);

Set @prevYearStart = dateadd(year, -1, @curYearStart);

With currentYTD (Area, Source, Total)

As

(

Select Area

,Src

,count(Distinct Account_No)

From #dim1

Where Filter_Code Not In ('4', '9', 'Unknown')

And [Date] >= @curYearStart

And [Date] < dateadd(day, datediff(day, 0, getdate()), 0)

Group By Area,Src

), previousYTD (Area, Source, Total)

As (Select Area

,Src

,count(Distinct Account_No)

From #dim1

Where Filter_Code Not In ('4', '9', 'Unknown')

And [Date] >= @prevYearStart

And [Date] < @curYearStart

Group By Area

,Src

)

SELECT area,source,heading, cnt

FROM

(

Select curYTD.Area

,curYTD.Source

,curYTD.Total As 'YTD 2010'

,prevYTD.Total As 'YTD 2009'

,(curYTD.Total - prevYTD.Total) As Variance

From currentYTD curYTD

Join previousYTD prevYTD On prevYTD.Area = curYTD.Area

And prevYTD.Source = curYTD.Source

) p

UNPIVOT

(cnt FOR heading IN

([YTD 2010],[YTD 2009],Variance)

)AS unpvt