Hi All, I have a Matrix Report in that format. Year Month Type Total MatrixCol1 MatrixCol2 MatrixCol'N' 2005 Jan T1 ?(17) 5 6 6 How can i Calculate the TOTAL (Which is a static Column) in Total Column by adding the MatrixCol1+MatrixCol2+MatrixCol'N'? MATRIX Columns are dynamic one. PS: I'm Using SSRS 2005 and MATRIX report. NOT SSRS 2008 and TABLIX. Thanks.

Darg and Drop your Measures Next to Type outside the MatrixCol Grouping.Dont forget to mark it as Answered if found useful Thanks, Rakesh M J MCTS,MCITP,MCSS Visit me lt;<http://mycubeandreports.blogspot.com/>>

Hi Rakesh, Thanks for your reply. Can u please give a step by step procedure. I am not clear about ur previous post. Can you give some detailed info? Thanks

Hello All, Anybody help me on this issue? Thanks

Add a column to your matrix OUTSIDE of your column group. Right now you have Year, Month, Type outside of the column group. Add one more column which is also outside of the column group. Then copy the same expression that is inside the group into the new column. So if your Matrix group expression is SUM(Fields!Sales.Value), then put this same expression in the new column. Should give you the total you are looking for.Martina White

Hi Peter, you Can have a look at the Design of the Report below. Kindly ignore the Names as i have taken a sample from Adventure Works ! Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi Rakesh, thanks for your post. Each row is grouped by Year, Month and Type. So is it make any impact calculating total?. Thanks.

Hi Peter, The Total for the Row will have No impact when Grouped by Year,Month,Type.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/