JanetStackpole
Programmer
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
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