7 Replies Latest reply on Sep 18, 2018 10:22 AM by maneesh.gaddam

    Aggregate by type

    Alexey Virov

      Hello everyone.

      Been playing with Tableau for a week, and it looks like a great tool, yet the learning curve is still high above me.

       

      I have a dataset like this

      typevalue
      Field11
      Field22
      Field310
      Field...4

       

       

      I need to make a bar chart where every column represents the sum of values from value column by custom logic. That is:

       

      Bar1 = SUM([value of Field1], [value of Field2], [value of Field3], [value of Field...])

      Bar2 = SUM([value of Field2], [value of Field3], [value of Field...])

      Bar3 = SUM([value of Field3], [value of Field...])

      Bar... = SUM([value of Field...])

       

      What would be the best way to achieve that? I created a bunch of calculated fields, but that looks like a mess to work with. Is it possible to do with just one calculated field or some other approach?