popsRme
asked on
Calculated Field in Matrix report SSRS 2005
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.