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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics