5 Replies Latest reply on Oct 13, 2016 10:03 AM by Thomas Gaffney

    Hierarchical Structure / Buckets / Totals

    Thomas Gaffney

       

      Hello- 

       

      I am attempting to create a calculated field that will allow me to show a Total for ***** side by side with a total for Soccer ***** and Baseballs.  My data is organized in a hierarchical structure and cannot be changed.

       

       

      TH1=***** 

       

      TH2=Soccer Ball, Baseball 

       

      TH3=Red, Yellow, Blue 

       

       

      Currently I can use field TH2 to show totals for soccer and baseballs, but cant get a grand total. Or, I can use field TH1 to show a grand total, but can't get the split between soccer and baseballs.

       

       

      Is there a way to bucket data into one field when you are dealing with a hierarchical structure? I tried an if/then statement, but I assume it is not working as Tableau would default all three conditions below into the 'Total *****' bucket.

       

       

      If TH1 ='*****' then 'Total *****' ELSEIF 

       

      TH2 ='Soccer Ball' then 'Soccer Ball' ELSEIF 

       

      TH2 = 'Baseball' then 'Baseball' Else 

       

      'Other' 

       

      End 

       

      Thank you!