Hi team, this is my inagural question, yeah!
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.
I would recommend separating the views into separate sheets and placing them on a dashboard together. Then, I would add this to the Ideas section!