Dynamic Selection Of Dimensions:
Drag Sales on the column and Subcategory on the Rows.

 

Create a String Parameter called “Select Dimension Parameter”. Then right click the parameter and click on show parameter.

Create a calculated field

Then drag the calculated field into the Rows shelf.

Dynamic Selection Of Measures:
Similarly, create a string parameter, then right click and click on Show parameter.

Create a calculated field

Then drag theĀ  calculated field on the Columns Shelf. In order to name the sheet accordingly right click on sheet 1 and edit the title. Click on insert and choose the parameter you have created.

 

 

The Data School
Author: The Data School