I'm guessing this is going to be one of those that has multiple solutions, but here's mine. Hopefully the number of possible Dimensions you want to see (or want to allow your users to see) is limited.
What I did was create a parameter (Dimension Selection 1) with all possible Dimension names I wanted them to be able to choose, and a (NONE). Then I created a calculated field (Dimension 1) tying a dimension to each parameter option. It is:
if [Dimension Selection 1]="Customer" THEN [Customer]
elseif [Dimension Selection 1]="Container" THEN [Container]
elseif [Dimension Selection 1]="Customer Segment" THEN [Customer Segment]
elseif [Dimension Selection 1]="Order Priority" THEN [Order Priority]
elseif [Dimension Selection 1]="Region" THEN [Region]
Then I pulled this Dimension into the rows, and showed the parameter control.
Then I duplicated this exact process twice (and of course more the more dimensions you want to allow them to see). All of these dimensions are displayed in the Rows, and you can select as many as you want.
Of course, potential issues occur with this. Selecting (NONE) will leave a blank space rather than removing the dimension entirely, you can repeat dimensions, etc. But this is one possible solution, hope it helps!
SelectableColumns.twbx.zip 1.1 MB
Hi Catherine...I have used your solution and it works very well. I was wondering if there is a way to still show the field labels and have them dynamically change as well. For example on Dimension 1 when I select Region I would like the the label to show up as Region rather than Dimension 1 or simply being blank.