0 votes
1 view
in BI by (17.6k points)

I have the following pivot table:

enter image description here

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/.

1 Answer

0 votes
by (47.2k points)

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 22, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Dec 22, 2019 in BI by Vaibhav Ameta (17.6k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...