Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
akhlaq768
Starting Member
12 Posts |
 Posted - 2008-11-19 : 07:28:24
|
| I have a matrix report with 2 column Year and Month by Row A 2007/2008 2008/2009 2007/2008 2008/2009 2007/2008 2008/2009Row Jan Jan Feb Feb Mar Mar A 100 200 300 20 25 15 B 200 250 50 30 45 19 1) Add % Variance column for each month, so comparing Jan 07/08 with Jan 08/092) Sort report by Month, starting from Apr and not Jan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 08:57:56
|
| you need to do it from query behind. find out the last year total along with each of totals and variance will be totalcurrent-totallast/totallast.For second part, you need to set up a temporary table with order set as 1 to 12 from Apr to Mar. then join with this table and sort on order field. |
 |
|
|
akhlaq768
Starting Member
12 Posts |
Posted - 2008-11-19 : 09:22:38
|
| thanks for the quick reply.. im still confused about how to design this in reporting service, im using a Matrix table |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 10:37:03
|
quote:
Originally posted by akhlaq768
thanks for the quick reply.. im still confused about how to design this in reporting service, im using a Matrix table
its better to do this in query behind and bring both prev year and current year values together into matrix. then apply aggregation based on column grouping and do as i posted earlier. |
|
|
|
|
|
|
additional column to work out % Variance