7 Replies Latest reply on Nov 21, 2018 2:04 PM by Sushmitha Reddy

    Adding a column at the end of a tabular worksheet having dual axis measures

    Anjali Sn

      I have a worksheet that looks as follows:

       

      tableau_screenshot.png

       

      As you can see on the Columns, there are couple of measures (which use dual axis for color conditional formatting i.e., like W2_1, W2_0 are dual axis measures; W3_1, W3_0 are dual axis and so on). Now I want to put another measure (WoW) such that it appears as the last column in the table. How do I do that? If I put it on the Rows, the column appears after the GOAL dimension in the table (i.e., comes as the 4th column in the talble). If I put it on the Columns, the whole table is screwed up like this:

       

      tab_screenshot2.png

       

      How do I get this done??

       

      Updated screenshot based on the below comment:

       

      tab_screenshot3.png

      Now I have everything in Measure Values. But now how do I have the conditional color formatting for each measure? I have a calculcated field for each measure i.e., W1, W2, W3 and so on... the calculcated fields are like this for each measure:

       

      IF [GoalSign] = '='

      THEN

      IF [M1] = [GoalCalc]

      THEN

      "True"

      ELSE

      "False"

      END

      ELSEIF [GoalSign] = '>='

      THEN

      IF [M1] >= [GoalCalc]

      THEN

      "True"

      ELSE

      "False"

      END

      ELSEIF [GoalSign] = '<'

      THEN

      IF [M1] < [GoalCalc]

      THEN

      "True"

      ELSE

      "False"

      END

      ELSEIF [GoalSign] = '>'

      THEN

      IF [M1] > [GoalCalc]

      THEN

      "True"

      ELSE

      "False"

      END

      ELSEIF [GoalSign] = '<='

      THEN

      IF [M1] <= [GoalCalc]

      THEN

      "True"

      ELSE

      "False"

      END

      END