I would like to create a Tableau view where a user can selectively expand or collapse rows in the table. With a hierarchy, I can expand and collapse entire dimensions, but what I'm hoping to do is be able to show some values at the higher level of view and others at the more granular level.
For example, in this excel table:
I can choose to show Dept A and Dept D at a more granular level (the Item level), while I have Dept B and C shown at a higher level. The Total lines I can add using the subtotal function in Tableau.