3 Replies Latest reply on Apr 18, 2018 11:56 AM by Deepak Rai

    Aggregate multiple dimensions within one field?

    Mathew Grimm

      Given one field with multiple, comma-separated dimensions, is there an easy way I'm missing to aggregate based on them? So given...

        

      CategoryValue
      a, b, c1
      a, b1
      a, c1
      a1
      b1
      c1

       

      I'd like it to return...

       

      CategorySum
      a4
      b3
      c3

       

      Obviously, I can extract as many custom calculations as I have variants and show the sums of those..

       

      But what if I don't know beforehand the dimensions that appear in Category? Or there are hundreds/thousands of variants in there? Seems like you really need to transform the data from the columns into more rows, but I'm not sure if that's easy within Tableau.

       

      Appreciate your thoughts!