8 Replies Latest reply on May 19, 2016 7:23 AM by Joe Oppelt

    comparing current period vs previous with date slider

    Sid Singh

      hi All

       

      i have to do comparison based on range of date filter, so basically lets say i have the date range selected as 10/1/2013<----->5/1/2014 it displays the sales for that time period.

      what i need now is one more sales calculation which will be for the previous period 10/1/2012-----5/1/2013. This will give me comparison of sales for the period selected in the slider and the sale from the previous period in the same sheet.

       

      Is it doable with date range slider. Any help will be appreciated.

       

      Attach is the sample workbook