I have a matrix report with two levels of column groups: Campus and Year

The report generates normally as you would expect it would. However, my client would like the Campus value to appear in the first column of the report on all rows instead of just the first row of each group of like Campus rows. Is there any way using the matrix construct to have the value for Campus appear on each row?

I thought about using a concatenate function on the two columns, but that isn't going to work because they want two separate columns to manipulate after exporting to Excel.

Any ideas?

Hello,

If I understand correctly, you want to display the Campus field all values in each rows rather than in each groups. Suppose we have a dataset (DataSet1) with Campus, Year and Details three fields. Please refer to the following steps:
1. Add a matrix in the report, fill with following values:
Row Group: Campus
Child Group: Year
Data: Details
2. Delete the first column, select Delete columns only.
3. Right click the new first column, select Insert Column -> Insert Group-Left.
4. Then, add Campus in the new column.

If there are any misunderstanding, please elaborate the issue for further investigation.

Regards,
Alisa Tang