Concatenate Cell Text or Value within Reports

Hello,

I'm trying to build a report within the Reports section of Planning that will concatenate a Member Name with the Cell Text or Value from the output of the report. I have added a Text column and written the below formula within the specific Cell.

MemberName("CommitID", 1): CellValue("Grid 1",1,D)

This works, to an extent but not the way I was hoping it would. This a specific row setup to pull in Bottom Level members of the various dimension on the row and in-turn pulls in 6 rows of data. However when the attempted Concatenation appears, it only populates with the first row of data and does not iterate over the entire 6 rows. Below is how it appears.