Finished single drill down graph:

In this example we will use the Sample - Superstore dataset.

First we need to drag SUM(Sales) onto Columns and Category onto Rows:

Then we need to create a string Parameter called 'category drill down':

Now we need to create a Calculated Field called 'category drill down':

Then drag the 'category drill down' Calculated Field onto Rows:

Now we need to create a Change Parameter action for this sheet under the Worksheet tab and call it 'category drill down' and ensure you set the ' clearing selection will' to be 'set value to':

To tidy up our sheet we need to right click on 'category drill down' and select to 'Hide Field Labels for Rows':

Now as we select each Category it will drill down to the Sub-Category:

Currently when we select each Category, the unselected Categories turn grey.

To prevent this we need to create a 'dummy' Calculated Field as below:

Drag this onto 'Detail':

Then create a Highlight Action for this sheet via the Worksheet tab as below:

Now when we select each Category the unselected Categories do not turn grey:

STOP HERE IF YOU JUST WANT A SINGLE DRILL DOWN, CONTINUE FOR DOUBLE DRILL DOWN

Finished double drill down graph:

First we need to create a string Parameter called 'sub-category drill down':

Now we need to create a Calculated Field called 'sub-category drill down':

Then drag the 'sub-category drill down' Calculated Field onto Rows:

Now we need to create a Change Parameter action for this sheet under the Worksheet tab and call it 'sub-category drill down' and ensure you set the ' clearing selection will' to be 'set value to'. Also ensure that the source filed you art targeting is 'category drill down':

Now you will be able to drill down from Category to Sub-Category to Manufacturer: