#WOW2025 | Week 39 | Can you create a drill-down?

Tableau, Workout Wednesday / By

Introduction

Today at work I started to create a two-level hierarchy bar chart, but then I realized one of the measures I was using was a MAX() value for the 2nd tier, but I wanted to sum those for the top tier. So I needed to create a drill down instead of a hierarchy. 

In Week 21 this year, Yusuke created a drill down challenge using parameters. This challenge will NOT use parameters, and is a pretty quick option if you just need a quick drill down functionality. 

Click to open in Tableau Public

Requirements

  • Size 1000×800
  • No Parameters
  • Create a bar chart showing sales by Category. When clicking on a ‘+’ next to the Category, it expands that category to its subcategories, and the category label replaces the ‘+’. 
  • Match formatting/tooltips

Dataset

This week is using Sample Superstore.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2025 in your description to make it searchable!

Share

After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2025 #Tableau and tag @WorkoutWednsday

Solution

Interactive

Scroll to Top