I need some help on collapsing hieararchies for some measures, while leaving the hierarchy displayed for other measures.
I've also attached a pdf that illustrates what I'm attempting.
In a crosstab view, I'm showing two measures that are sub-divided by two attributes that form a hierarchy. I need to show the full hierarchy for Measure 1, but I need to collapse the hierarchy for Measure 2, and just show its total.
In excel, this is effortless (by manipulating the expand/collapse features) I can't figure out how to accomplish this via Tableau.