7 Replies Latest reply on Jun 19, 2017 10:26 AM by Shinichiro Murakami

    Pretty specific labeling need

    Renaud Guilbert

      Hey everyone,

       

      I have this chart that's almost perfect:

       

      What I have right now:

      - 2 values per year over 5 years

      - Label: Value amount for the 2nd value

      - Label: % of difference between the 2nd value and the 1st

       

      What I would like to have

      - 2 values per year over 5 years

      - Value amount for the 2nd value AND the 1st value

      - % of difference between the 2nd value and the 1st

       

      My problem is that the Label function applies equally to ALL values involved in Label, and not individually.

       

      I know of the trick to only show the values on certain measures (create a calculated field that looks like this -> sum(if Measure = x then y end) ) but since my % is a calculated field that depends on the previous value, I cannot use it or else my % will be erroneous.

       

      Do you guys have any solutions? I packaged the sheet in question.

       

      Thanks!

       

      PS: My tableau version is 10.2