11 Replies Latest reply on Mar 12, 2017 9:47 PM by chakradhar kakani

    Dynamically Grouping multiple rows into one single row

    chakradhar kakani

      Hello Tableau Users,

       

      I'm trying to group different dimensional values into one row.. for example if my screenshot I have data by hour and I want group the rows which are equal to 0 in one single row and shows it as "=0" in the dimension. ANother thing is the DISPLAY BY in my dimension is a parameter and I can change the views like i can select by different dimensions. So I want which every dimension value they select in the parameter i want all rows which contain 0's to be rolled up into one single row and show as "=0" and rest all what it is.

       

      Thanks

      Appreciate the help