5 Replies Latest reply on Jul 3, 2018 6:55 AM by Shinichiro Murakami

    YTD and YoY metrics comparison Month over Month

    Cyrille Thybert

      Hi All,

       

      I need to produce a dashboard that shows YTD and YoY evolution per month.

       

      YTD = from jan to the selected month (from Jan 2018 to May 2018)

      YTD Last Year = same than YTD but last year (from Jan 2017 to May 2017)

      YoY = Period : 1 year from current month-11 to current month. (ex. From Jun. 2017 to May 2018)

      YoY last year = same than YoY but last year . (ex. From Jun 2016 to May 2017)

       

      I'm trying to compare those value month over month

       

      MonthVol YTDVol YTD Last YearYTD vs YTD Last year Vol YoYVol YoY last yearYoY vs Yoy Last year
      Jan1000900-10%120000130000-8%
      Feb20002100+5%122000125000+8%
      Mar30003300+10%110000105000-5%
      Apr................
      May
      Jun.
      Jul.
      Aug.

       

      I'have already done those YTD and YTD-1 in the attached workbook but the only way to do what I want, seems to create one variable per Month per KPI. so 12*6 .. around 70 Calculations.

       

      Do you have any idea to make it quicker, smarter than creating 70 Calculations ?

       

      Thank you for your tips,

      C.