Adding column after Matrix total

<P>Greetings,</P>
<P>I am new to reporting services and am struggling with trying to add a column to the end of matrix report that has totals.&nbsp; You can see a jpg of the report at http://www.catertots.com/matrix.jpg What I need to do is repeat the school code that is in the first column into another column that follows the total.&nbsp; </P>
<P>Any help would be much appreciated.</P>

Hi,

Matrices are a bit difficult when it comes to adding new columns. I can only think of two ways that you could do it (and both are a bit sleazy).

1. Add a 'Total' column within your kid group so that when you group by kid, the total will automatically display. Then when you add your total column within the matrix, name it 'School' and put an IF in the measure textbox to say display school code when not in scope of the column groups. However, there will be a problem in ordering the kid group if there is a kid group greater then 'Total'

2. Add a second matrix, the same as the first and hide alll the column groups and just put it next to the first matrix.

|||Thank you for the reply.