2 Replies Latest reply on Jul 24, 2018 7:19 AM by Sumitra Kurkal

    Can you show data where each row has a separate header?

    Sumitra Kurkal

      Hi All

       

      I am using Tableau 10.5.2.

      My Data is in the format as shown below. Row_seq 1 has the headers and row_sql =2 has the values.

      id           freq       row_seq    col1              col2                           col3                      col4

      NPI-1     M           1            4/1/2018          1/1/2018            11/1/2017              9/1/2017

      NPI-1     M           2            G                           G                      G                           G

      RGA-3   M           1            5/1/2018            4/1/2018            3/1/2018              2/1/2018

      RGA-3   M           2            G                                R                      R                      R

      IAF-1     Q           1            Q2 2018              Q1 2018              Q4 2017              Q3 2017

      IAF-1     Q           2            R                           R                           G                      G

       

      Report should look like :

                    4/1/2018            1/1/2018            11/1/2017          9/1/2017

      NPI-1     Green Dot           Green Dot         Green Dot         Green Dot


                                                                

                    5/1/2018            4/1/2018            3/1/2018            2/1/2018

      RGA-3   Green Dot          Red Dot            Red Dot               Red Dot

                                

                                                             

                    Q2 2018              Q1 2018              Q4 2017              Q3 2017

      IAF-1        Red Dot            Red Dot              Green Dot          Green Dot        

       

       

      Is this even possible?

       

      Thanks for your time!

      Sumi.