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



      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.