SSRS difference/Varience Column between 2 years
Posted on 2011-05-05
I have an SSRS report that is grouped by Month for the rows, and Grouped by the Years for the Columns. When I run the report, SSRS displays years 2008 and 2009, and the aggregated values for each month. What I need to do next is calculate the Difference between the values for each Month. I found this article ID: 25351542 but did not understand what to do. Please keep the solutions within the scope of what SSRS can do.
My dataset already has all the table information created so I have the counts, Fiscal Year, And Month ready. I just need to subtract the 2 report item values for each month in the Matrix.