1 Reply Latest reply on Sep 14, 2012 12:28 PM by Tracy Rodgers

    Collapsing hierarchies

      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.

       

      many thanks!