Introduction to Group for Tablix (Matrix and Table) - Part 3

This post is about how to convert Table into Matrix

One of the key differences between a tablix structured as a table and a tablix structured as a matrix is the Details group. A table usually (but not always) includes the Details group, whereas the matrix eliminates the Details group to display aggregated values only. Therefore, it's necessary to manually remove the detail group from the report to convert the report layout from a table to a matrix.

Drag and drop the Data column into relevant Row/Column Group

Delete the Details Row Group, and then delete the irrelevant headers.

This will shows as below same as matrix:

Cheers!