I have read several articles & I don't see a solution I like (or simply don't understand the solution).
I have a row group for Business Unit field with the remaining desired fields in the detail row.
I want Business Unit to appear on every row of course.
I tried hiding the col for the row group & moving the Business Unit to row detail, but when exported to Excel it reserves a column for the hidden col. This does not look nice cosmetically.
What are my other options, remembering I'm exporting to Excel & want to retain cells by row/col.
View Complete Post