5 Replies Latest reply on Jun 13, 2017 9:33 AM by Hari Ankem

    Multiple Groups In a Case Statement

    Anthony Knisely

      Hey everybody,

       

      I need some help with a multiple group calculation in tableau.

       

      The data looks like this:

       

      Rows

      Product A

      Product B

      Product C

      Product D

      Product E

       

      Groups

      Group 1 - A, B, C

      Group 2 - B, C, D

      Group 3 - A, E

       

      I'd like to have these three groups displayed together on a line chart. Ideally, the three groups would sum the data and show it over time by the individual group and not the product level. I've included a sample workbook of what the data represents.

       

      I found this - Multiple/overlapping values in a case statement? , but the data set is so large custom SQL would not be an option for me.

       

      Any help is appreciated, thanks