3 Replies Latest reply on Dec 14, 2012 8:36 AM by Matylda Borchert

    YoY difference in % for a dynamic time frame

    Matylda Borchert

      Hi,

      I need absolute values as well as YoY difference for sales in % for the current year and a previous year. The challenge is that I want to compare the same time frames.

       

      In my example year 2012 includes just values for the first 3 quarters (Q1-Q3); year 2011 is so far completed (Q1-Q4), at the end, these are the numbers that I want to report:

       

      Sales 2011 (Q1-Q3): 952.188

      Sales 2012 (Q1-Q3) : 931.154

      YoY difference: -2,21%

       

      How can I achieve this?

      Thanks for your support, Matylda