A reader asked me how to add grand totals a matrix (A Sample of Matrix in SSRS).
It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here.
Suppose you have a very simple 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.