3 Replies Latest reply: Aug 6, 2017 11:44 AM by Pankaj Thakur RSS

    calculate difference between the same quarter over 4 years

    Anat Dagan

      Below (and attached) is a pivot table that displays values for the same quarter  over 4 different years.

      I am trying to add a column that will show the difference between the same quarters over the last 4 years (e.g. Q1 2017-Q1 2016 , Q1 2018-Q1 2017 etc.)

      and another column with the %difference (e.g (Q1 2017-Q1 2016) / Q1 2016... etc...)

       

      How can this be achieved?