MS 2005 Reporting Services Matrix - % Change Issue ....Help!

Hello Everyone,

I have been tasked with creating a report using Reporting Services from an excel report that was wasting a lot of manual effort and time. I have searched boards and I am having the hardest time trying to find a way to do the following in Reporting Services within a Matrix:

Spring Summer Fall

2005 2006 2007 %Change 2005 2006 2007 % Change 2005 2006 2007 %Change

Reponses 219 310 410 100 100 200 300 100 2000 3000 200 -2800

FRC% 102% 103% 200% 97% 23% 25% 10% -15% 20% 32% 10% -22%

===========================================================================================

I can not find out how to do a percent change (the column in red) subtracting just the final or most right two columns of the resulting matrix columns, not an average or some other function over the entire row....

Please help, I know others have had the same issue...

Thank You,

I would think you would just need to incorporate this into your select statement. Select the difference between the two most recent years as percentChange. Then in your report, add a column with the percentChange field as the data value.|||Thank You for your reply...I will try that and post back...|||

Yep that was the answer...

Thanks...