4 Replies Latest reply on Feb 7, 2019 10:56 AM by xabrina Estevez

    Using LOD Calcs to Compare Latest Year to Prior Year

    xabrina Estevez

      Hello,

       

      I used the following video Using LOD Calcs to Compare Latest Year to Prior Year - YouTube  to create a chart that calculates the change between latest year to prior year.

       

      However, my fiscal year starts in November so when I want ti compare our Nov 2018 ( current Fiscal year) to Nov 2017 (Prior Fiscal year) is not doing anything because it taking nov 2018 vs 2019.

       

      Is there a better way to fiscal YTD vs past fiscal YTD ??

       

       

      Help please