Can we list dimensions on one single select dropdown parameter and measures in another single select parameter and use two calcs that reference the selected parameters to create the needed cross tab ? Sorry, could had sent a sample, but I am travelling ..
Please attach mocked up sample data as twbx and illustrate your expected view.
We can achieve dynamic dimension with help of parameter.
But can select and show only one dimension at a time.
Write a parameter with list of dimension names
Then write calculation
CASE [Parameters].[Dimension Names]
WHEN 'Region' THEN [Region]
WHEN 'Segment' THEN [Segment]
WHEN 'Shipmode' THEN [Ship Mode]
And drag that calculations in rows shelf.
Thanks Megha for looking into it.
Parameter allows to select only one value in dropdown list. But the requirement is to select Multi dimensions as we have for the measures.
As requested, I have attached the expected view along with the workbook.