4 Replies Latest reply on Nov 3, 2015 9:00 PM by Carlos Flores

    Using latest month, but also applying it to previous years . YoY work

    Carlos Flores

      I have data that i use to create Year over Year calculations, i would like to set it up to automatically pick up the latest

      month, my issue is that it limits to the newest month but  does not use the other years.. which kind of makes sense

       

       

      I want it to use October as the latest month, but also show October 2014, October 2015, and October 2016.

       

      Right now, i use the min()=0 and set it for the deepest month, so it feeds me October 2016, but it wont pick up 2015, and 2014.

       

      any ideas?