3 Replies Latest reply on Feb 18, 2016 1:25 PM by Shinichiro Murakami

    Calculations to convert column to row

    Jenny Chen

      I simplify my dataset to the table as below. Here is my question, I need to create four Calc fields highlighted in yellow.

       

      "Current-1 Status" calculation field should display the Status from previous Quarter Q4/2015, which is Green.

      "Current-2 Status" calculation field should display the Status from Q3/2015, which is N/A.

      "Current-3 Status" calculation field should display the Status from Q2/2015, which is Green.

      "Current-4 Status" calculation field should display the Status from Q1/2015, which is Yellow.

       

      I can't figure out the Calc to get what I want. Can someone help me with the Calc or guide me to the right direction?

      Tableau Calc 1.png

       

      Thanks so much!