1 Reply Latest reply on Nov 28, 2018 11:10 PM by Shinichiro Murakami

    FYTD dynamic comparison

    Richard Michaels

      Hello All,

      Good evening.

      I have a question I'm having a hard time answering. ON the attached, I have created a calculated field and parameter to show my fiscal YTD results. ONce the parameter goes past Oct (my fiscal start date), the values start over for the next fiscal year (e.g. If the parameter is set to July 2019 then all values from Oct 2018 - July 2019 are shown, if the parameter is set to October 2018, only the values for Oct 2018 are shown).

       

      With this parameter, I would like to show the percentage increase/decrease that would compare this Fiscal year to date to the previous fiscal year to date. Is that possible with the workbook I have attached?

       

      Any and all help is much appreciated!!!!

       

      Rich