3 Replies Latest reply on Mar 14, 2014 12:29 PM by Natalia Gatti

    YOY Growth and YTD Calculations

    Jason Back



      I am trying to create a table with month YOY growth and YTD growth for sub total column AND have a range of dates slider bar controlling the dates.


      Two challenges here (example file attached):


      1. Sub total columns are always being calculated based on previous full year results instead of corresponding YTD.  (ex. for 2013, Jan & Feb results are being compared to 2012 full year).


      2. Problem with slider bar filter (ex. if I put filter for Feb 2006 to Feb 2013, Jan 2007 growth is showing based on Feb 2007 and so forth, and leave the end columns empty like Dec 2007).


      Solutions to any of my problems above would be much appreciated.  Thank you!