9 Replies Latest reply: Jan 17, 2017 1:04 PM by John Henry RSS

    How to calculate Year over Year growth measures

    John Henry

      I have a dataset (see simple example below) that I need to calculate YoY metrics (calculation: current year divided by last year minus 1) by any combination of country, region, Year, qtr, and month.  For example, I'd like to have filters for country, region, year, qtr, and month and then create a KPI chart that showed the YoY % growth.  For example, if I chose US->Central->2016->Q1->Nov from filters, I would get a YoY % decline of -50% ($5/$10-1).  If I chose LAC->Brazil->2016->Q1 from filters, I would get a YoY % decline of -33% ($30/$45-1).  Keep in mind that I will have many years in this dataset, so it needs to be dynamic.

       

      CountryRegionFiscal YearFiscal QtrMonth$
      USCentral2015Q1Nov10
      Dec15
      Jan20
      2016Q1Nov5
      Dec10
      Jan15
      LACBrazil2015Q1Nov10
      Dec15
      Jan20
      2016Q1Nov5
      Dec10
      Jan15