Once you add a crosstab, it asks for a dimension for rows and a dimension for columns. My question is simple. The dimension for rows in my case only contain serial numbers and I want to hide(and shrink) it. How to do it.
What I have tried.
1. Set cell display to none. and shrink = true. This removes text. Doesn;t shrink column.
2. Set in script on create cell for cell# display none. This is funny. This moves the data rows, but headers remains at same place. Doesn't shrink too.
3. Set element visibility to false. Again no shrinking.
How to do it.