5 Replies Latest reply on May 10, 2017 2:36 PM by John Healey

    Simple Sum and Grouping by a Portion of Text

    John Healey

      I have a table that has hours and then an itemcode. The itemcode is labeled like "/TCER" or "/TCAB" or "/SCTY" or "/SCASDF", etc. I want to be able to tell Tableau to find all the instances where it starts with "/TC" and to add all the hours up (and put it in a bar) then add up all the "/SC" beginning items and put that in a bar, and so on.

       

      I need help! Beginner here so go easy please!