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 Oct 16, 2020 in BI by Sudhir_1997 (53.1k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...