When I create a row group in a tablix, a column is created to house the group. When I export to excel, this column is merged and will not allow normal sort processes.
How can I "hide" the column that is created for the group so that it is not merged into excel?
I'm working in SSRS 2012.
On the column, the Hidden property is set to true.