Calculated Field in Matrix report SSRS 2005
Posted on 2013-06-22
I'm developing a report from a SP, using SSRS 2005. I'm using a matrix report to provide the base info. What I'm needing is to insert a % calculation between each time period. Here's what I'm looking for:
2012 % +/- 2011 % +/- 2010 % +/- 2009
Total Apps 110 ? 150 ? 130 ? 50
I have the data for each year rendering correctly. What I'm needing is the % +/-, which is based on a comparison between the current and previous year (the ?). For example, the first ? would be 110/150 * 100. Is there a way to do this?