How to Build a Dynamic Drill-down Table in Tableau

The following post is a part of a series looking at different options for mimicking Pivot Tables in Tableau: Building Pivot Tables in Tableau Series.

This option is great for situations where the drill-down path might not always be the same.

For this example, we are going to create two drill-down paths : 

Category > Sub-Category > Product Name

State > Category > Manufacturer

Step #1: Create Level Parameters

Create a Parameter that lists the options for Level 1.

Repeat for each drill-down level.

Step #2: Create Display Formulas

Create a calculated field that identifies the field that should be displayed based on each level’s parameter selection.

Repeat for all levels.

Step #3: Create Viz

The last step is to add the Level calculations to the sheet.

Step #4: Formatting and Final Touches

Once your sheet is on a dashboard, I suggest adding instructions for the end-user.  It is also a good idea to test the sizing of the columns and rows to make sure the data is clearly displayed when the levels change.

Have any comments or questions? Feel free to reach out on Twitter: @Data_Katrina

Like what you are reading?

Get articles sent to you when they are posted.
Comments are closed.