6 Replies Latest reply on Oct 17, 2016 5:00 AM by Petros Katsoulas

    % of difference from

    Petros Katsoulas

      Hi all,

       

      I need to create a table that shows a measure for two years (e.g. 2015,2014) and the % difference of this measure between the two years. When i prepare a table calculation, i have a value for 2015 (increase or decrease) and no value for 2014. What i need is as i show in the attached example to have one line with the actual value of the measure in 2015, one with the actual value in 2014 and another with the % difference between the two years. I don't want to have a line for % difference in 2014 (and if possible to hide the label of 2015 in front of the difference). Is there a way to do this?

       

      Thanking you in advance for your answers