I have a matrix that displays posted amount by day for each month of the year. Each Client has a different recall period so I need the subtotal to calculate only for the recall months. Current: 2011 2010 Date May Apr Mar Feb Jan Dec Nov Oct Sep Aug Jul Jun Total 5/1 0 10 20 10 50 10 0 0 0 0 0 0 100 5/2 10 20 20 0 10 10 10 0 0 0 0 0 80 5/3 20 20 5 10 0 10 5 5 5 0 0 0 80 Need: recall Period of Feb 2011 2010 Date May Apr Mar Feb Jan Dec Nov Oct Sep Aug Jul Jun Recall Total 5/1 0 10 20 10 50 10 0 0 0 0 0 0 40 5/2 10 20 20 0 10 10 10 0 0 0 0 0 50 5/3 20 20 5 10 0 10 5 5 5 0 0 0 55

Hi Missa-Lissa, According to your description, I understand that you would like to calculate the value of month when client recall months. Is the month a static value or a parameter that is passed to the matrix? - If month is as a parameter, please try the following expression in subtotal. =Iif(InScope("matrix_column"), Sum(Fields!value.Value), SUM(IIF(Fields!Month.Value=Parameters!Month.Value,Fields!value.Value,0))). Note: matrix_column is a column group name. - If it is a static value, you can replace the parameter with the static month mentioned in the expression above. For more information about Reporting Services 2005 with Matrix, please see link, http://blogs.msdn.com/b/robertbruckner/archive/2009/08/10/tablix-multiple-subtotals-are-easy-aka-goodbye-inscope.aspx If you have any question, please feel free to ask. Thanks, Eileen

The month is static and I can't use a parameter because there are 30+ clients and not all clients have the same recall month. There are at least 6 different recall months. I was able to create a seperate matrix for the recall total which I'm now calculating and updating the sql table. However, now the issue is that I can't get the recall totals for each day on the same page as the main matrix. why do I feel i'm making this more difficult then it needs to be?

Hi Missa-Lissa, Could you please help me clarity the “totals for each day”? I am not sure what your requirement is. If you only want to show total for each day, please use table instead of matrix, and drag date field and value field to the cell in table. If not this case, could you please supply more details about the issue? Such as data structure of your report, and step by step you have done to design your report and so on. And then, we could help you better. If possible, could you please send the report and relevant datasource to me like following. Once I receive your email, I will give you a feedback as soon as possible. E-mail: sqltnsp AT Microsoft.com (Please replace AT with @). Please send me with the following format: Subject: MSDN/TechNet forum question: <Thread Title> Attachments: <files> Hi Eileen, ThreadURL:<URL> <Additional information> Thanks, Eileen