4 Replies Latest reply on Mar 6, 2019 10:33 PM by Adam Aliz

    YTD and % Change YOY based on Fiscal Year April

    Adam Aliz

      Hi,

       

      I want to calculate YTD and % change YOY  based on fiscal month April . if i click month December 2017. it should calculate from April 2016.

       

      1.i need to apply filter ,  so i i click December 2017 in the filter tab, it should calculate from April 2016 and show the cumulative value in December 2017 Month.

       

      2.And, it should also calculate the % change YOY

       

      See the screenshot below for ilustration

       

       

       

      Attached is the superstore workbook.