This content has been marked as final. Show 4 replies
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.