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:



      Product A

      Product B

      Product C

      Product D

      Product E



      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