I have the following pivot table:
Is there a way to collapse the "Type" section, so I only have three rows:
- 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/.