SSRS Matrix

Question

I want my matrix to look like below.

I am storing my all of the data except AvgA and AvgB in the database.

How to design a matrix in such a way that it fetches data from the database calculates the average?

And I want all of this using single matrix.

Thanks you

Answer 1

You need a add a dummy grouping for that in the matrix

Choose TestNo as RowGroup field

Add Category field as column group

Add a parent group for column group with expression as

=LEFT(Fields!Category.Value,1)

for the Category add option Add Total after

At this stage matrix looks like this

Now delete the row containing top column group (ie red one above)

Now run the report and you'll get desired output

ie below

The sample rdl can be found here

Sample RDL

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My MSDN Page
My Personal Blog
My Facebook Page

Answer 2

It worked!!! Thanks.... 

Sample provided by helped a lot