Menu
I have the following pivot table:
Is there a way to collapse the "Type" section, so I only have three rows:
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/.
613
In Tableau one can create a hierarchy using multiple dimensions, which enables an easier drill down on the views. The drill-down is done by clicking the + or – symbol on respective views. This way of expanding and collapsing the hierarchies can be cumbersome when it needs to be performed on multiple views.
To drill down and drill up for individual dimension members in a hierarchy: Right-click a table header and select Drill Down or Drill Up . This is often referred to as non-uniform drill down because you expose only the members of interest instead of exposing all the members of a given level.
To remove a hierarchy: In the Data pane, right-click (control-click on a Mac) the hierarchy and select Remove Hierarchy. The fields in the hierarchy are removed from the hierarchy and the hierarchy disappears from the Data pane.
Hierarchies will do what you are looking for. https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.html#qs_hierarchies.html.
On your data source pane, drag the Title dimension and drop it on top of the Type dimension. 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.
149
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
