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.
