Can I add a row to a matrix based on specific rows in the matrix rather than all?

Question

Hi,

I have a matrix in a report that returns five rows. effectively this

r1 | s11 | s12 | s13 | s14

..

r5 | s51 | s52 | s53 | s54

I need to add a sixth row that computes a value based on the values in row 1 and row 5.

r6 | s11+s51 | s12 + s52 | etc....

Is this possible and if so, how do I do it?

Answer 1

Like Mark said, to do it in a query is pretty simple.

Alternatively, you could add another row to your matrix, and use an expression to add the values of the first and last value in each column:

=First(Fields!s.Value) + Last(Fields!s.Value)