Create one dimension entry for each of the dimensions, and use conditional display of the dimension. Use an expression like
=If(Concat(fieldname, ';') like '*this_dimension*', 1, 0)
For each dimension, replace the fieldname with the correct fieldname and the like string (*this_dimension*) with the value of the dimension in fieldname. Keep the wildcards *.
This approach allows you to select more than one dimension and display the table with one or two or more dimensions (or all dimensions for the Concat() option if nothing is selected).
Can you check if this is inline with what you are looking to get?
When we select Region from the Dim list box
When we select Country from Dim list box
Drawback of this approach is that you can only view one dimension at a time. So I have Dim list box 'Always One Selected Value Only' which will force it to only one selection at all times and won't even allow clearing it out as well.
Community_228042.qvw 153.2 K