How to collapse a sub-section in tableau crosstab

Question

I have the following pivot table:

Is there a way to collapse the "Type" section, so I only have three rows:

• Movie
• TV Episode
• Grand Total

Basically, I'd like to be able to expand each section by clicking into it. Otherwise, I'll have thousands of values that would require tons of scrolling to view all.

Here is one example, but this seems overkill (creating buttons with actions) and not quite practical to do it quickly: http://www.thedataschool.co.uk/ben-davis/drill-hierarchies-tableau-website-style-navigation/.

Answer 1

• This can be done by Hierarchies https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.html#qs_hierarchies.html.

• Drag the Title dimension and drop it on top of the Type dimension on your data source pane. This will then prompt you to give the hierarchy a title. Hierarchies allow you to drill up and down.

• The classic example of a hierarchy is the way dates function. You can drill up and down from year to day.

If you also want to learn Tableau and make your career in it then I would suggest you must take up the following Tableau Desktop Certification course online.