Hi Luis

Select WeekRange as WeekRange,

[Open] as 'Open', [Resolved] as 'Resolved', [Pending] as 'Pending', [Other] as 'Other'

From

(

Select weekRange, Year, Status from ##TempInteractionData

) As SourceTable

Pivot

(

Count(Status) for Status in ([Open], [Resolved], [Pending], [Other])

) As PivotTable

Order by year

I did this. Now what happens is for a particular week when the year changes from 2013 to 2014 the data is displayed twice. The same will happen if i include month (which will also be necessary in the future).

The data is displayed as follows:

WeekRangeOpenResolvedPendingOther

12/15 ~ 12/212230

12/22 ~ 12/280210

12/29 ~ 01/042010

01/05 ~ 01/11173611

01/12 ~ 01/182111911

01/19 ~ 01/2583200

12/29 ~ 01/041400