Creating a Matrix with a static column

[Anonymous]

Hello,

I have data that I am displaying in a Matrix.

The first column is a name, and then the rest of the columns are the month in which the data is collected. I would like to insert a column that is just a more detailed description of the first column. The end result would be a matrix with two static columns and then fluctuating date columns, but I can't find out how to insert the 'description' row into the matrix.

Any help would be greatly appreciated.

[andhiii079845 · Accepted solution]

The addional information belongs to the name? Than create a new column in the table where the name column is. Insert in this column your description and than add this column to "row" to the matrix. 

Turn off under Format -> row header the +/- icon

And make a drilldown and also turn off "stepped layout":

[Jack145]

Do you know how to add a total in bold to this?

[Anonymous]

I'll try that now, thank you for the quick response

[andhiii079845]

Let me know if you missing something, please mark my post as a solution if it was helpfull.

[Anonymous]

It worked great. Thanks for the help!