I worked this out myself. For the months column, I used the following expression:

=Sum(Fields!numOfLessons.Value)

That worked.

Thanks for your help.

Thanks, I followed all your steps, as follows (screenshots included for each step):

In the rows part, drag your Teacherno field,

in the columns part drag your lessonmonth field,

and in the...

Thanks for your reply.

I think you are using VS2008, as my screen doesn't look like yours - I'm using VS2005. I don't have all those options in the drop...

I can't access the greyed-out cell underneath 'Total' to put an expression in it, it's automatically generated when I click on 'Subtotal'. Yes, I'm using a matrix to display this.

I...

Anyone who can help?? I just need a simple SUM of the values in each row. I thought that the built-in subtotal function would be fine.

Here's what my matrix looks...

Thanks for your reply. How do I do that?