7 Replies Latest reply on Dec 27, 2016 10:03 AM by mohammad.walid.0

    Transfer Columns to row in Tableau

    jing.yang.2

      I will need a table as below in Tableau

       

      SalesID Results Q1      Q2        Q3      Q4
      001     Target 105      106       105     111
      001     Actual 104      107       100     120
      001 MeetTarget reddot  greendot   reddot  greendot

       

      The target and actual volumes are in two different columns in the data source.  What should I do to

      1. convert Target and Actual from Column to Rows,
      2. let tableau to compare the target and actual and then give it red or green color to indicate if it meets the target or not?