I have a matrix with variable rows & columns (user can select what variable they want for row and what they want for columns in addition to ranges of dates...).
What I want to do is when they select 'Sales Year' or 'Sales Month' as a column that I could DYNAMICALLY put in another column that would be the percent increase over the previous value - what I am not sure how to do is identify what value is in the row
ex - this is how the matrix comes out if the user selects Month & Year (pretty graph at the top - then the matrix underneath)
2006 2007 2008
01 - January $1,000 $1,500 $3,000
...
what I would LOVE to output is similar to:
2006 2007 % 2008 %
01 - January $1,000 $1,500 +50% $3,000 +100%
I could even put up with another % column in between 2006 & 2007, but only want to turn the column on if it makes sense to compare.
So the questions are
1) how do I look backwards in a Matrix to do the math
2) how do I dynamically 'shut off' a column?
Years ago I did something similar in Crystal - and am trying to do same in SSRS 2005. Even a general starting direction would get me going
Thanks in advance!
What I want to do is when they select 'Sales Year' or 'Sales Month' as a column that I could DYNAMICALLY put in another column that would be the percent increase over the previous value - what I am not sure how to do is identify what value is in the row
ex - this is how the matrix comes out if the user selects Month & Year (pretty graph at the top - then the matrix underneath)
2006 2007 2008
01 - January $1,000 $1,500 $3,000
...
what I would LOVE to output is similar to:
2006 2007 % 2008 %
01 - January $1,000 $1,500 +50% $3,000 +100%
I could even put up with another % column in between 2006 & 2007, but only want to turn the column on if it makes sense to compare.
So the questions are
1) how do I look backwards in a Matrix to do the math
2) how do I dynamically 'shut off' a column?
Years ago I did something similar in Crystal - and am trying to do same in SSRS 2005. Even a general starting direction would get me going
Thanks in advance!