Hi All, I'm creating a matrix and in last columern I want to add a difference field between previous columns (not an addition but difference): department Y2011 Y2010 Subdifference dep1 250 200 50 dep2 120 100 20 Is it possible to do it in a matrix?

You can use expressions but there is no sum function for you you have to write your own logic in this case or handle it in the sql query itself -------------------------------------------------------- Surender Singh Bhadauria

in excel there is such function as sumif, is there anything similar? meaning is it possible to write sumif (filed.value, "Y2011") - sumif(field.value, "Y2010")?

Hi All, I'm creating a matrix and in last columern I want to add a difference field between previous columns (not an addition but difference): department Y2011 Y2010 Subdifference dep1 250 200 50 dep2 120 100 20 Is it possible to do it in a matrix? Its doable and one of my thread posting should help you http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/b1a8abf5-9303-443d-84ff-f5033a1d4935 ThanksRajkumar Yelugu

almost, but it is not possible to edit subtotal expression, or it is not possible to add a derived columen in a matrix...

but it is not possible to edit subtotal expression Why are'nt you able to edit the subtotal expression ? Thanks .Rajkumar Yelugu

it is gray, and cannot even select in report desiner...

Hi, Just to pitch in .....correct me if i am wrong.. You have only 2 columns currently....is this going to increase in future...if not why not consider a table instead of matrix where you can add another column which will be the difference between the two.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Yes, I have 2 columns, but somehow is doesnt sum correctlly if i add grouping in a table... i'll do without it...