This can be done using the conditional enabling technique of dimensions and expressions.
Just take the list of columns into one data Island table and create a list box using the column from data island table to list down the columns in list box.
Now create a straight table with the required columns. Each dimension/mesure column select the check box conditional and provide the following condition.
=SubStringCount(Concat(Dimension_Detail, '|'), 'Brand')
Dimension_Detail is the column from Data Island table contains the list of columns.
Brand is the current dimension column that you want to enable conditionally.
Hope this helps,
Adhoc reporting is possible with conditional enablement of dimensions or expressions only in straight table, but not with table box.
if you have dimension only, then you can create an expression and hide it or don't enable the expression.
if you don't have measures in your source table, create a dummy measure, create a dummy expression on top of it.
- hope it helps you :-)