How to Build a Dynamic Drill-down Table in Tableau
Comments are closed.
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
Create a Parameter that lists the options for Level 1.
Repeat for each drill-down level.
Create a calculated field that identifies the field that should be displayed based on each level’s parameter selection.
Repeat for all levels.
The last step is to add the Level calculations to the sheet.
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