Solved

Calculated Field in Matrix report SSRS 2005

Posted on 2013-06-22
1
776 Views
Last Modified: 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?
0
Comment
Question by:popsRme
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
ID: 39268447
afaik a matrix can have only one cell that is an aggregate (sum, count, first, etc.), not two with an expression.  

So, the only way to pull this off would be to have a cross join in the SP that is the data source for a tablix, with the headers as the first row, column names something like year_1, year_1_pct, year_2, year_2_pct, etc.

Good luck.
Jim
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Where clause in stored procedure 8 50
Not selecting duplicate data 6 46
SSRS Access Remotely 5 55
Add total to a tablix with ReportItem values 15 39
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now