[Microsoft BI] Add Row Or Column Totals To Matrix

Add row or column totals to matrix

Suppose the table with sales data for products sold from each store.

You want to rearrange the data so it shows the stores vertically, all products horizontally, and the Sales Amount at each intersection. Finally you want to show totals at the bottom and also to the right.

  

Matrix will be a perfect choice for this purpose with no extra coding on your part.

Solution – create a matrix and then add totals to row and column

The steps are very straightforward. I am going to show the screen shots from SSRS 2008 here.

Here is a matrix without any configuration yet.

Point the cursor to the Rows cell, an icon appear on the upper right corner. Click the icon, you will see the list of columns from your dataset. Select Store.

  

For the Columns cell, select Product.

  

For the Data cell, select SalesAmount.

Now, right-click the data cell, you will see choices under Tablix. Select Add Totals, and then Row.

Repeat the above step to create a total next the column Product.