Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate percentage change from two years

Status
Not open for further replies.

JanetStackpole

Programmer
Sep 30, 2005
24
US
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
 
I ended up doing in data. I understand 2008 makes it easer to accomplish this
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top