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?