I have a worksheet that I'm putting dimension columns onto on the row shelf, it's basically a detail drill-through sheet that is accessed via action from the main worksheet. The problem I'm having is that once I get past a certain number of dimensions, the worksheet starts crowding columns to the left, so that column headers disappear and column values are separated by commas. I want all these items on the row shelf to be displayed properly and in full view when the worksheet is accessed. Does anyone know how that is accomplished? I haven't seen a resize or auto-resize option anywhere.
Thanks in advance,
I finally found it:
Analysis -> Table Layout -> Advanced...
In the "Table Options Window" there is a section called "Rows". Adjust the number of maximum levels for rows here.