SSRS 2008 - Matrix Control and Sub Totals

Question

I am trying to get multiple subtotals in a matrix control, any ideas how to get it? thx



---

GMK

Answer 1

Hello,

Based on the screen shot, it seems that three are three row group (“Store Name”, ”Product Name” and supposing the other is “Status” ) and one column group (“Date”) in the matrix data region.
Please refer to the following steps:
1. In the Row Groups pane, click the “Product Name” group and add a subtotal to this group. A new row “Total” will display inside the “Store Name” group.
2. Specify the value expression for the “Total” row as follows:
=SUM(IIF(Fields!Status.Value=”Available”,Fields!datafield.Value,0))
3. Repeat the above steps and use the following expression to summary the “Not Available” data:
=SUM(IIF(Fields!Status.Value=”Not Available”,Fields!datafield.Value,0))
If I have any misunderstanding, please let me know.

Regards,
Fanny Liu

If you have any feedback on our support, please click here.

---

Fanny Liu
TechNet Community Support