Monday, January 14, 2013 3:52 PM
I am trying to get multiple subtotals in a matrix control, any ideas how to get it? thx
Tuesday, January 15, 2013 1:40 AMModerator
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:
3. Repeat the above steps and use the following expression to summary the “Not Available” data:
If I have any misunderstanding, please let me know.
If you have any feedback on our support, please click here.
TechNet Community Support