Matrix: how to get the running difference between rows
Hi,
I am working on a matrix report shown as below: the first one is what i got now, the second one is what I desire to have
Quarter1
January
February
March
Total
CCC
2006
9
9
19
37
2007
2
17
15
34
CHTDS
2006
5
15
10
30
2007
6
8
9
23
FTA
2006
4
9
3
16
2007
4
4
6
14
GDA
2006
9
8
12
29
2007
15
7
16
38
Quarter1
January
February
March
Total
CCC
2006
9
9
19
37
2007
2
17
15
34
Diff
-7
8
-4
-3
CHTDS
2006
5
15
10
30
2007
6
8
9
23
Diff
1
-7
-1
-7
FTA
2006
4
9
3
16
2007
4
4
6
14
Diff
0
-5
3
-2
GDA
2006
9
8
12
29
2007
15
7
16
38
Diff
6
-1
4
9How can I get the difference between 2006 and 2007 for each category as highlighted in yellow?
Thanks,
xhh
October 23rd, 2007 7:14pm
Group by Row, then right click on the group row, add row (inside below).. At corresoponding place write the expression like = Fields!Jan.Value - Fields!Feb.Value
Let me know if you find any difficulty.!SqlUser2011
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2011 11:13pm
No answer?
March 6th, 2011 12:16am
But we dont want the difference between months.
We want the difference between years. The row difference!
Free Windows Admin Tool Kit Click here and download it now
March 12th, 2011 5:18am