1 Reply Latest reply on Feb 24, 2016 9:06 AM by Shinichiro Murakami

    I cant organize row and colums

    Josue Morales

      I have this view table in tableau  

                                                                                                 Time

                 Types                               route                       1                  2

      ----------------------------------------------------------------------------------------------------

           (1,5,6)                                       r1                     (0 957 7)          (0 570 35)

                                                             r2                    (0 0 3)               (0 0 2)

      ------------------------------------------------------------------------------------------

       

      But i want the results in this format, but i cant separate the data

                                               

                                                                            Time

         Types                     Route                         1              2

      --------------------------------------------------------------------------

           1                              r1                            0               0

                                           r2                            0               0

      --------------------------------------------------------------------------------

           5                              r1                           957           570

                                           r2                           0                 0

      ---------------------------------------------------------------------------------------

           6                              r1                             7             35

                                           r2                             3              2

       

      I tried with division but its not working. Thanks

       

      In the attached file, the sheet 3 contains the data using division, where i can get result but division by division (i want get all data depending on filters). On sheet 4 i tried create same view of sheet 3 using all data without division. I guet the results, but it is all in 1 row, and i want to separate that data to get a better view, just like the example above

       

      Mensaje editado por: Josue Morales File added