Calculate percentage change from two years

[JanetStackpole]

I am trying to create a report in SQL Server Reporting Services 2005 that compares a count of people served each month to the previous year:

Service Month
Service Year 1 2
2010 1,456 1,502
2011 1,712 1,692
% Change 18% 13%

My difficulty is in creating the percentage of change. I am assuming that I need to use the inscope function, but I am not exactly sure how to do this.

Thanks for your assistance

 

[SonicG]

I haven't had a need for this type report yet, but there is always a first time.

Check out:

http://my.opera.com/duncans/blog/in...ge-growth-or-change-between-two-group-members

It explains both 2005 and 2008 solutions. This may help you on your question.

 

[JanetStackpole]

Thanks, I will give it a go.

 

[JanetStackpole]

I ended up doing in data. I understand 2008 makes it easer to accomplish this