1 Reply Latest reply on Jan 29, 2019 8:20 AM by patrick.byrne.0

    Comparison with Overlapping dates from Previous to Current date

    Rasell Lingad

      I need help with this project.

      First scenario, Date Range : Nov 01-2017 - Nov 30, 2017

       

      2nd scenario Date Range : Nov 01-2017 - Nov 30, 2018. (I have expanded the end date to 2018).

      I'm not sure if this is right but as you can see there is overlapping of the dates from Previous year to current year.

       

      I'm getting the same result from different date Range.

      Can someone help what is the best way to show the result as the 2nd scenario?