I'm new to SSRS 2005 and I'm having a terrible time trying to figure this out. This should be an easy one, but I need it ASAP. So it's worth 500 points if you can help me out.
All I need to do is take the current year sales and subtract it from the prior year sales in a SSRS 2005 matrix. I think this can be done using the "Previous Function", but for the life of me I can't seem to get it to work. The sales field is in the detail section of the matrix and has a value of "=Sum(Fields!Sales.Value)"
Please see the image I provided for a clearer understanding.
As I said, I'm new to SSRS 2005, so please give examples and make it as idiot proof as possible.