8 Replies Latest reply on Sep 12, 2018 12:55 PM by Shinichiro Murakami

    Grouping Dimension and Sumif Dimension Contain Keyword

    Thomas Lin

      Hi All,

      I am new to tableau. I am sure what I am trying to do is not complex and as it can be easily achieved in Excel using sumif. Hopefully someone in the Tableau Community can help?


      I am trying to generate the following results. The dimensions are grouped based on the '|1| or |2|. if the Range contain any of the 4 criteria sum the metric.


      Any suggestion would be greatly appreciated.