|
-
May 8th, 2007, 09:21 AM
#1
Thread Starter
Fanatic Member
Reporting Services matrix problem
Hello,
I have a report in SQL reporting services 2005 in which I am using a matrix. Basically, it dynamically generates two years (ie 2006 and 2007) as a column header. this works great. Problem I'm having is a want to do a change year over year in one column at the end:
example
Insurer 2006 2007
Insurer1 10 25
Insurer2 13 45
Insurer3 30 18
I can't figure out how to create my own column on a matrix which just calulates the change year over year. All that is available is a subtotal which is not what I want. Here's what I would like to see:
Insurer 2006 2007 Change
Insurer1 10 25 15
Insurer2 13 45 32
Insurer3 30 18 -12
I have to use a matrix because the year is based on user selection. If the years were not going to change, I would have just used a table instead of a matrix and hard coded the year. can something like this be done in a matrix?
Thanks,
Strick
Last edited by stricknyn; May 8th, 2007 at 09:26 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|