3 Replies Latest reply on Jan 27, 2016 4:42 AM by Andrew Watson

    Calculation - Slider





      I have a date range slider in my sheet and want to display Current YTD Vs Prior YTD values for that date range on selection of the months in the filter.



      So in the attached book , if I move the slider say from Jan 2014 - Jun 2014 then the calculation to display for the sales is (Jan 2014 - Jun 2014) - (Jan 2013 - Jun 2013)



      How can I achieve the YTD comparion calculations. I am using a month slider.